Search Discussions

118 discussions - 1,127 posts

  • I've been looking at the tsearch patch a bit, and I think there needs to be more thought given to the permissions required to mess around with tsearch configuration objects. The TSParser objects ...
    Tom LaneTom Lane
    Jun 13, 2007 at 5:39 pm
    Aug 15, 2007 at 4:33 am
  • SELECT 1 FROM test.dbo.a_003 gets about 60,000 records per second SELECT '1' FROM test.dbo.a_003 gets about 600 records per second. The cause is that postgres describes the return column as "unknown" ...
    Dann CorbitDann Corbit
    Jun 11, 2007 at 7:24 pm
    Jun 13, 2007 at 4:54 am
  • I'm again looking at way the GUC variables work in load distributed checkpoints patch. We've discussed them a lot already, but I don't think they're still quite right. Write-phase ----------- I like ...
    Heikki LinnakangasHeikki Linnakangas
    Jun 6, 2007 at 1:19 pm
    Mar 11, 2008 at 8:06 pm
  • A message entitled "Having Fun With PostgreSQL" was posted to Bugtraq today. I haven't read through the paper yet so I don't know if the author discusses security problems that need attention or if ...
    Michael FuhrMichael Fuhr
    Jun 17, 2007 at 1:12 am
    Jun 28, 2007 at 6:16 am
  • It seems that time-based GUC variables can be spelled like 1h but not 1hr 1min but not 1m 1s but not 1sec This is inconsistent and confusing. I don't object to the ones on the left as being the ...
    Tom LaneTom Lane
    Jun 18, 2007 at 2:16 pm
    Jun 22, 2007 at 4:14 pm
  • I was just looking at implementing some query tuning/debugging features in pgAdmin, and was looking to use EXPLAIN output to get a list of the base tables involved in the users' query. Unfortunately ...
    Dave PageDave Page
    Jun 13, 2007 at 9:25 am
    Jun 18, 2007 at 6:16 pm
  • We've changed the on-disk database format in 8.3, so we have an opportunity to change other things also. There is a patch thats been on the patch queue for some time called numeric508, submitted Dec ...
    Simon RiggsSimon Riggs
    Jun 18, 2007 at 2:34 pm
    Jul 17, 2007 at 10:01 pm
  • I am still very unhappy about the way the MSVC builds work. Although we have managed to make it sort of work with the buildfarm script, it is distinctly fragile. Last night, for example, I had a ...
    Andrew DunstanAndrew Dunstan
    Jun 24, 2007 at 5:23 pm
    Jul 25, 2007 at 8:48 am
  • http://www.sigaev.ru/misc/tsearch_core-0.52.gz Plan was: 1) rename FULLTEXT to TEXT SEARCH in SQL command done 2) rework Snowball stemmer's as Tom suggested done 3) ALTER FULLTEXT CONFIGURATION ...
    Teodor SigaevTeodor Sigaev
    Jun 21, 2007 at 5:44 pm
    Jun 27, 2007 at 2:14 pm
  • I've been reflecting a bit about whether the notion of deferred fsync for transaction commits is really safe. The proposed patch tries to ensure that no consequences of a committed transaction can ...
    Tom LaneTom Lane
    Jun 21, 2007 at 10:15 pm
    Jun 23, 2007 at 8:25 pm
  • I notice that in 8.3, when I kill the postmaster process with SIGKILL or SIGSEGV, the child processes writer and stats collector go away immediately, but the autovacuum launcher hangs around for up ...
    Peter EisentrautPeter Eisentraut
    Jun 2, 2007 at 8:19 pm
    Jun 13, 2007 at 6:49 pm
  • Here's results from a batch of test runs with LDC. This patch only spreads out the writes, fsyncs work as before. This patch also includes the optimization that we don't write buffers that were ...
    Heikki LinnakangasHeikki Linnakangas
    Jun 13, 2007 at 11:09 am
    Jun 20, 2007 at 9:43 pm
  • I just had an epiphany, I think. As I wrote in the LDC discussion, http://archives.postgresql.org/pgsql-patches/2007-06/msg00294.php if the bgwriter's LRU-cleaning scan has advanced ahead of ...
    Tom LaneTom Lane
    Jun 26, 2007 at 8:25 pm
    Mar 11, 2008 at 8:47 pm
  • During one of HOT stress tests, an asserition failed at tqual.c:1178 in HeapTupleSatisfiesVacuum(). The assertion failure looked really strange because the assertion checks for HEAP_XMAX_COMMITTED ...
    Pavan DeolaseePavan Deolasee
    Jun 28, 2007 at 5:49 pm
    Sep 26, 2007 at 9:14 am
  • Hi, I spent the best part of the day trying to work this out - I was working on a system setup with PG 8.2, and wanted to work with 8.3 for development. I installed as follows: 1. CVS checkout 2. ...
    Eddie StanleyEddie Stanley
    Jun 25, 2007 at 11:57 am
    Jun 27, 2007 at 2:13 pm
  • [summarising discussion on -patches] The situation with this patch is that I now have it in a state where I think it could be applied, but there is one blocker, namely that we do not have a way of ...
    Andrew DunstanAndrew Dunstan
    Jun 8, 2007 at 12:32 pm
    Jun 12, 2007 at 3:11 am
  • I've been testing the new UUID functionality in 8.3dev and noticed that UUIDs are sorted using memcmp in their default in-memory layout, which is: struct uuid { uint32_t time_low; uint16_t time_mid; ...
    Robert WojciechowskiRobert Wojciechowski
    Jun 14, 2007 at 7:59 pm
    Jul 17, 2007 at 4:57 am
  • Hi This is a description of the GSoC work I've so for on readonly support for PITR slaves. I'm looking for any kind of comments on this - I want to make sure that I work in a direction that the ...
    Florian G. PflugFlorian G. Pflug
    Jun 6, 2007 at 2:11 pm
    Jun 7, 2007 at 9:13 pm
  • I'm seeing some applications where it appears that there would be value in introducing asynchronous messaging, ala "message queueing." <http://en.wikipedia.org/wiki/Message_queue The "granddaddy" of ...
    Chris BrowneChris Browne
    Jun 19, 2007 at 9:50 pm
    Jun 20, 2007 at 5:02 pm
  • First a comment: At CONNX Solutions Inc., we believe sincerely that we should do whatever is necessary to make our customers prosper. This means creation of excellent tools and being responsive to ...
    Dann CorbitDann Corbit
    Jun 12, 2007 at 8:41 pm
    Jun 13, 2007 at 9:55 am
  • I've got a requirement to produce some additional stats from the server while it executes. Specifically, I'm looking at table interaction stats to make it easier to determine replication sets ...
    Simon RiggsSimon Riggs
    Jun 29, 2007 at 12:14 pm
    Jul 2, 2007 at 5:43 pm
  • The current discussion about the tsearch-in-core patch has convinced me that there are plausible use-cases for typmod values that aren't simple integers. For instance it could be sane for a type to ...
    Tom LaneTom Lane
    Jun 15, 2007 at 4:14 pm
    Jul 17, 2007 at 5:15 am
  • While looking at the tsearch-in-core patch I was distressed to notice that a good fraction of it is derived files, bearing notices such as /* This file was generated automatically by the Snowball to ...
    Tom LaneTom Lane
    Jun 2, 2007 at 8:05 pm
    Jun 18, 2007 at 4:59 pm
  • I know we have talked about how to avoid legal email signatures on this list. One idea would be for a small percentage of our users to ignore emails with a legal signature. I know I am less likely to ...
    Bruce MomjianBruce Momjian
    Jun 9, 2007 at 10:14 pm
    Jun 12, 2007 at 10:36 pm
  • english '{en_GB, en_US, C}' I suppose, that locale name always has a dot separator exept C locale --- which is well known exception
    Jun 22, 2007 at 4:13 pm
    Jun 30, 2007 at 11:14 pm
  • Hi, I was looking to start development on the following TODO entry. Add a separate TRUNCATE permission Currently only the owner can TRUNCATE a table because triggers are not called, and the table is ...
    Nick BarrNick Barr
    Jun 9, 2007 at 5:28 pm
    Jun 13, 2007 at 2:54 pm
  • Hi, I noticed that lazy vacuum acquires an exclusive lock at the end, to be able to truncate the table. This is not a surprise. If it cannot acquire the lock, it simply skips truncating the table and ...
    Alvaro HerreraAlvaro Herrera
    Jun 28, 2007 at 9:17 pm
    Jul 26, 2007 at 2:13 pm
  • Is anyone currently working on this TODO item? "During index creation, pre-sort the tuples to improve build speed" http://archives.postgresql.org/pgsql-hackers/2007-03/msg01199.php A few of us would ...
    Jun 27, 2007 at 7:49 pm
    Jul 7, 2007 at 7:41 pm
  • Hi Marc, Is there a written procedure about creating tarballs? I'd like to start working on 8.3 RPMs and I want to know what I should to to create a tarball. Regards, -- Devrim GÜNDÜZ PostgreSQL ...
    Devrim GÃNDÃZDevrim GÃNDÃZ
    Jun 5, 2007 at 1:09 pm
    Jun 29, 2007 at 1:08 am
  • Hello, Assume the following: index on: (id, adate) constraint CHECK(adate '01-01-2007' AND adate < '04-01-2007'); The planner will not use the index listed above. It does work if we have an index on ...
    Joshua D. DrakeJoshua D. Drake
    Jun 1, 2007 at 8:06 pm
    Jun 7, 2007 at 12:26 am
  • Hi all, I've benn biten twice by this one: I enabled archiving on both my pgsql servers. the archive command was a simple gzip on an nfs mounted dir. Now the nfs server crashed. Both wal space filled ...
    Jun 7, 2007 at 3:01 pm
    Sep 27, 2007 at 5:42 am
  • Out of curiosity I'm checking what consequences some other future grammer changes might have for us. Today I checked out full spec compliant GROUP BY syntax including ROLLUP, CUBE, and GROUPING SETS. ...
    Gregory StarkGregory Stark
    Jun 26, 2007 at 12:26 pm
    Jun 26, 2007 at 4:12 pm
  • These two calls make our remote queries via libpq about twice as fast on average. It seems to me like it might be a nice addition to the core product's libpq (I poked it into the spot where the Nagle ...
    Dann CorbitDann Corbit
    Jun 11, 2007 at 10:17 pm
    Jun 12, 2007 at 12:33 am
  • I'd like a single backend to never reuse a temp tablespace that is actively being used so that large queries won't randomly conflict with themselves. That's pretty certain to draw complaints, IMHO. ...
    Simon RiggsSimon Riggs
    Jun 4, 2007 at 7:14 pm
    Jun 7, 2007 at 3:44 pm
  • I have been looking at the syslogger code in connection with the CSV log output proposal, and I'm quite concerned about the way it translates every \n into \r\n for Windows output. This has several ...
    Andrew DunstanAndrew Dunstan
    Jun 1, 2007 at 9:15 pm
    Jun 4, 2007 at 10:18 pm
  • Hello, I'm having a big trouble with the index size! I have looked for a solution in the internet, but the solutions that I found don't fit for me! I developed a new data type using C and add this ...
    Rodrigo SakaiRodrigo Sakai
    Jun 3, 2007 at 2:41 am
    Jun 4, 2007 at 1:21 pm
  • Hello everyone, I have created a new data type "mychar". How can I specify a limit for it? This (unlimited version) works fine: create table table_a(col_a mychar); This gives an error: create table ...
    Michael EnkeMichael Enke
    Jun 27, 2007 at 12:42 pm
    Jun 29, 2007 at 1:30 pm
  • If we tries to drop the table on which autovacuum is running, we have to wait finish of the vacuum. However, the vacuuming effort goes to waste for the table being dropped or rewritten. Meanwhile, ...
    ITAGAKI TakahiroITAGAKI Takahiro
    Jun 13, 2007 at 6:28 am
    Jun 22, 2007 at 5:31 am
  • I'm working with a customer that recently discovered that some code had generated the following nice query... SELECT ... WHERE table_id = 92838278! AND ... So their production server now has several ...
    Jim C. NasbyJim C. Nasby
    Jun 9, 2007 at 1:45 am
    Jun 9, 2007 at 2:22 pm
  • The ECPG regression tests appear to be broken on MinGW (see buildfarm trout and vaquita). Please tell me that this isn't a line ending problem like it appears on cursory inspection. cheers andrew
    Andrew DunstanAndrew Dunstan
    Jun 14, 2007 at 11:48 am
    Jun 14, 2007 at 1:12 pm
  • When does this bug date to? is it possible it's related to the performance drop immediately following a vacuum analyze we've been seeing? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com
    Gregory StarkGregory Stark
    Jun 7, 2007 at 9:07 pm
    Jun 8, 2007 at 3:09 am
  • Is vacuuming any table supposed to zero the statistics for all shared tables? Doesn't that have implications for autovacuum? The example below is in 8.2.4 but I'm seeing similar behavior in 8.1.9 and ...
    Michael FuhrMichael Fuhr
    Jun 7, 2007 at 1:20 am
    Jun 7, 2007 at 7:00 pm
  • I would like to inform, that New Zealand changed DST rules and new timezone files are available. See ...
    Zdenek KotalaZdenek Kotala
    Jun 25, 2007 at 10:38 am
    Sep 13, 2007 at 3:43 am
  • In GiST, for each new data type we support we're expected to provide (among other things) a function to determine whether a query is consistent with a particular index entry (given an operator/ ...
    Jun 27, 2007 at 4:32 pm
    Jul 2, 2007 at 8:47 pm
  • Hello, triggers in PostgreSQL are cascading by default. From section 34.1. of the 8.2 manual: "If a trigger function executes SQL commands then these commands may fire triggers again. This is known ...
    Chris MairChris Mair
    Jun 26, 2007 at 2:04 pm
    Jul 2, 2007 at 9:50 am
  • Bruce, please make sure to keep the list copied on replies. I think there is an important bug here and I don't want it to get lost just because I lose track of it. I'm also crossposting to ...
    Alvaro HerreraAlvaro Herrera
    Jun 29, 2007 at 12:50 am
    Jun 29, 2007 at 3:18 am
  • With today's CVS code (originally noticed with 8.2beta3), on a PC where INT_MAX=0x7FFFFFFF=2147483647 postgres=# select version(); version ...
    Patrick WelchePatrick Welche
    Jun 28, 2007 at 6:16 pm
    Jun 29, 2007 at 2:41 am
  • Thank you to everyone for input on the naming of Feature "X". The clear winner of the parameter naming was synchronous_commit, which would imply we refer to the new feature as Asynchronous Commit in ...
    Simon RiggsSimon Riggs
    Jun 24, 2007 at 10:23 am
    Jun 26, 2007 at 5:24 am
  • I finally was able PL/R to compile and run on Windows recently. This has lead to people using a Windows based client (typically PgAdmin III) to create PL/R functions. Immediately I started to receive ...
    Joe ConwayJoe Conway
    Jun 21, 2007 at 10:27 pm
    Jun 22, 2007 at 12:12 pm
  • AFAICS, Peter's recent incomplete updating of error message wording should have broken every last man jack of 'em. And yet there's still some green to be seen. I think we are looking at problems in ...
    Tom LaneTom Lane
    Jun 4, 2007 at 7:30 am
    Jun 11, 2007 at 7:43 am
Group Navigation
period‹ prev | Jun 2007 | next ›
Group Overview
grouppgsql-hackers @

120 users for June 2007

Tom Lane: 213 posts Gregory Stark: 60 posts Andrew Dunstan: 59 posts Simon Riggs: 54 posts Alvaro Herrera: 53 posts Heikki Linnakangas: 47 posts Bruce Momjian: 46 posts Magnus Hagander: 36 posts Teodor Sigaev: 35 posts Joshua D. Drake: 32 posts Dann Corbit: 29 posts Greg Smith: 28 posts Dave Page: 22 posts Jim Nasby: 21 posts Peter Eisentraut: 19 posts ITAGAKI Takahiro: 17 posts Josh Berkus: 17 posts Andreas Zeugswetter: 14 posts Florian G. Pflug: 14 posts Stephen Frost: 12 posts
show more