Re: [PATCHES] [pgsql-patches] Recalculating OldestXmin in a long-running vacuum

2007-02-03 Thread Heikki Linnakangas
Tom Lane wrote: Heikki Linnakangas <[EMAIL PROTECTED]> writes: I have two runs of DBT-2, one with the patch and one without. Patched: autovac "public.stock" scans:1 pages:1285990(-0) tuples:25303056(-2671265) CPU 95.22s/38.02u sec elapsed 10351.17 sec Unpatched: autovac "public.stock"

[PATCHES] Fix "database is ready" race condition

2007-02-03 Thread Markus Schiltknecht
Hi, is there a good reason to print the "database system is ready" message in StartupXLOG() in xact.c? It has a) nothing to do with xlog and b) opens a small race condition: the message gets printed, while it still take some CPU cycles until the postmaster really gets the SIGCHLD signal and s

Re: [PATCHES] [HACKERS] \copy (query) delimiter syntax error

2007-02-03 Thread Andrew Dunstan
Michael Fuhr wrote: On Sat, Feb 03, 2007 at 10:52:29AM -0600, Andrew Dunstan wrote: I'd say fix psql. Not sure how far back we should backpatch it. It's interesting that this has been there since 8.0 and is only now discovered. The problem is new in 8.2 because COPY (query) doesn't s

Re: [PATCHES] Index split WAL reduction

2007-02-03 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- He

Re: [PATCHES] Index split WAL reduction

2007-02-03 Thread Bruce Momjian
Sorry, please disregard. Newer patch being added. --- Bruce Momjian wrote: > > Your patch has been added to the PostgreSQL unapplied patches list at: > > http://momjian.postgresql.org/cgi-bin/pgpatches > > It will

Re: [PATCHES] Index split WAL reduction

2007-02-03 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- He

[PATCHES] Remove log segment and log_id fields from pg_controldata

2007-02-03 Thread Bruce Momjian
The original discussion of this patch was here: http://archives.postgresql.org/pgsql-hackers/2006-11/msg00876.php Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the Post

Re: [PATCHES] Bundle of patches

2007-02-03 Thread Bruce Momjian
I assume we have taken all the patches from here we want. --- Teodor Sigaev wrote: > The 1C (http://www.1c.ru/) company kindly permits to publish a set of patches > we (Oleg and me) developed during our work on porting of th

Re: [PATCHES] [HACKERS] elog(FATAL)ing non-existent roles during client

2007-02-03 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- Ga

Re: [PATCHES] this patch correct upper and lower case for translated month's and day's names

2007-02-03 Thread Bruce Momjian
Would you please modify this patch to use the functions in oracle_compat.c? --- Pavel Stehule wrote: > Hello, > > this patch correct bug in to_char function with incorrect uppercased month's > or day's name. > > Regards >