[COMMITTERS] pgsql: Add URLs for : * Speed WAL recovery by allowing more than one

2008-03-17 Thread Bruce Momjian
Log Message: --- Add URLs for : * Speed WAL recovery by allowing more than one page to be prefetched This involves having a separate process that can be told which pages the recovery process will need in the near future. > http://archives.postgresql.org/pgsql-general/2007-12/msg006

[COMMITTERS] pgsql: Advance multiple array keys rightmost-first instead of

2008-03-17 Thread Tom Lane
Log Message: --- Advance multiple array keys rightmost-first instead of leftmost-first during a bitmap index scan. This cannot affect the query results (since we're just dumping the TIDs into a bitmap) but it might offer some advantage in locality of access to the index. Per Greg Stark.

[COMMITTERS] pgsql: Add TODO: > o Recreate pg_xlog/archive_status/ if it doesn't

2008-03-17 Thread Bruce Momjian
Log Message: --- Add TODO: > o Recreate pg_xlog/archive_status/ if it doesn't exist after > restoring from a PITR backup > > http://archives.postgresql.org/pgsql-hackers/2007-12/msg00487.php Modified Files: -- pgsql/doc: TODO (r1.2344 -> r1.2

[COMMITTERS] pgsql: Fix our printf implementation to follow spec: if a star parameter

2008-03-17 Thread Tom Lane
Log Message: --- Fix our printf implementation to follow spec: if a star parameter value for a precision is negative, act as though precision weren't specified at all, that is the whole .* part of the format spec should be ignored. Our previous coding took it as .0 which is certainly wrong

[COMMITTERS] pgsql: Add to TODO: > > * Consider Cartesian joins when both relations

2008-03-17 Thread Bruce Momjian
Log Message: --- Add to TODO: > > * Consider Cartesian joins when both relations are needed to form an > indexscan qualification for a third relation > > http://archives.postgresql.org/pgsql-performance/2007-12/msg00090.php Modified Files: -- pgsql/doc: TODO

[COMMITTERS] pgsql: Add URL for: o Allow COPY to report error lines and

2008-03-17 Thread Bruce Momjian
Log Message: --- Add URL for: o Allow COPY to report error lines and continue This requires the use of a savepoint before each COPY line is processed, with ROLLBACK on COPY failure. > http://archives.postgresql.org/pgsql-hackers/2007-12/msg00572.php Mo

[COMMITTERS] pgsql: Add to TODO: > > * Allow SSL key file permission checks to be

2008-03-17 Thread Bruce Momjian
Log Message: --- Add to TODO: > > * Allow SSL key file permission checks to be optionally disabled when > sharing SSL keys with other applications > > http://archives.postgresql.org/pgsql-bugs/2007-12/msg00069.php Modified Files: -- pgsql/doc: TODO (r1.2341 -

[COMMITTERS] pgsql: Add: > > * Reduce BIT data type overhead using short varlena

2008-03-17 Thread Bruce Momjian
Log Message: --- Add: > > * Reduce BIT data type overhead using short varlena headers > > http://archives.postgresql.org/pgsql-general/2007-12/msg00273.php Modified Files: -- pgsql/doc: TODO (r1.2340 -> r1.2341) (http://anoncvs.postgresql.org/cvsweb.cg

[COMMITTERS] pgsql: Add to TODO: > * Reduce file system activity overhead of

2008-03-17 Thread Bruce Momjian
Log Message: --- Add to TODO: > * Reduce file system activity overhead of statistics file pgstat.stat > > http://archives.postgresql.org/pgsql-general/2007-12/msg00106.php > Modified Files: -- pgsql/doc: TODO (r1.2339 -> r1.2340) (http://anoncvs.postgre

Re: [COMMITTERS] pgsql: Avoid incrementing the CommandCounter when

2008-03-17 Thread Bruce Momjian
Added to TODO: * Consider if CommandCounterIncrement() can avoid its AcceptInvalidationMessages() call http://archives.postgresql.org/pgsql-committers/2007-11/msg00585.php --- Tom Lane wrote: > Log Message: >

[COMMITTERS] pgsql: Add to TODO: > * Consider if CommandCounterIncrement() can avoid

2008-03-17 Thread Bruce Momjian
Log Message: --- Add to TODO: > * Consider if CommandCounterIncrement() can avoid its > AcceptInvalidationMessages() call > > http://archives.postgresql.org/pgsql-committers/2007-11/msg00585.php Modified Files: -- pgsql/doc: TODO (r1.2338 -> r1.2339)

[COMMITTERS] pgsql: Add URL for: * Add SQL:2003 WITH RECURSIVE (hierarchical)

2008-03-17 Thread Bruce Momjian
Log Message: --- Add URL for: * Add SQL:2003 WITH RECURSIVE (hierarchical) queries to SELECT > http://archives.postgresql.org/pgsql-hackers/2007-11/msg01334.php Modified Files: -- pgsql/doc: TODO (r1.2337 -> r1.2338) (http://anoncvs.postgresql.org/cvswe

[COMMITTERS] pgsql: Add: > > o Remove pre-7.3 pg_dump code that assumes pg_depend

2008-03-17 Thread Bruce Momjian
Log Message: --- Add: > > o Remove pre-7.3 pg_dump code that assumes pg_depend does not exit Modified Files: -- pgsql/doc: TODO (r1.2336 -> r1.2337) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/TODO?r1=1.2336&r2=1.2337) pgsql/doc/src/FAQ:

Re: [COMMITTERS] pgsql: Enable probes to work with Mac OS X Leopard and other OSes that

2008-03-17 Thread Peter Eisentraut
Tom Lane wrote: > Peter Eisentraut <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> Gen_dummy_probes.sed? How likely is that to work on Windows? > > > > I think if they can run Gen_fmgrtab, they can get this to work. > > They can't. They can't run Gen_fmgrtab or they can't get this to work?

[COMMITTERS] pgsql: Add URL for: * Improve text search error messages >

2008-03-17 Thread Bruce Momjian
Log Message: --- Add URL for: * Improve text search error messages > http://archives.postgresql.org/pgsql-hackers/2007-11/msg01146.php Modified Files: -- pgsql/doc: TODO (r1.2335 -> r1.2336) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/TODO?r1=1.

[COMMITTERS] pgsql: Added to TODO: > * Improve text search error messages > >

2008-03-17 Thread Bruce Momjian
Log Message: --- Added to TODO: > * Improve text search error messages > > http://archives.postgresql.org/pgsql-hackers/2007-10/msg00966.php > > > * Fix /contrib/ltree operator > > http://archives.postgresql.org/pgsql-bugs/2007-11/msg00044.php Modified Files: -- pg

Re: [COMMITTERS] pgsql: Enable probes to work with Mac OS X Leopard and other OSes that

2008-03-17 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Peter Eisentraut <[EMAIL PROTECTED]> writes: >>> I think if they can run Gen_fmgrtab, they can get this to work. >> >> They can't. > They can't run Gen_fmgrtab or they can't get this to work? They can't run Gen_fmgrtab. The MSVC

[COMMITTERS] pgsql: Add TODO: > > o Fix server restart problem when the server was

2008-03-17 Thread Bruce Momjian
Log Message: --- Add TODO: > > o Fix server restart problem when the server was shutdown during > a PITR backup > > http://archives.postgresql.org/pgsql-hackers/2007-11/msg00800.php > Modified Files: -- pgsql/doc: TODO (r1.2333 -> r1.2334)

[COMMITTERS] pgsql: Adjust TODO spacing.

2008-03-17 Thread Bruce Momjian
Log Message: --- Adjust TODO spacing. Modified Files: -- pgsql/doc: TODO (r1.2332 -> r1.2333) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/TODO?r1=1.2332&r2=1.2333) pgsql/doc/src/FAQ: TODO.html (r1.840 -> r1.841) (http://anoncvs.

Re: [COMMITTERS] pgsql: Enable probes to work with Mac OS X Leopard and other OSes that

2008-03-17 Thread Peter Eisentraut
Tom Lane wrote: > [EMAIL PROTECTED] (Peter Eisentraut) writes: > > Switch from using DTRACE_PROBEn macros to the dynamically generated > > macros. Use "dtrace -h" to create a header file that contains the > > dynamically generated macros to be used in the source code instead of the > > DTRACE_PROBE

[COMMITTERS] pgsql: Add TODO URL for: * Consider increasing the number of default

2008-03-17 Thread Bruce Momjian
Log Message: --- Add TODO URL for: * Consider increasing the number of default statistics target, and reduce statistics target overhead > http://archives.postgresql.org/pgsql-hackers/2008-01/msg01066.php Modified Files: -- pgsql/doc: TODO (r1.2331 -> r1.2332)

Re: [COMMITTERS] pgsql: Enable probes to work with Mac OS X Leopard and other OSes that

2008-03-17 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Gen_dummy_probes.sed? How likely is that to work on Windows? > I think if they can run Gen_fmgrtab, they can get this to work. They can't. regards, tom lane -- Sent via pgsql-committers mailing list (pgs

Re: [COMMITTERS] pgsql: Enable probes to work with Mac OS X Leopard and other OSes that

2008-03-17 Thread Tom Lane
[EMAIL PROTECTED] (Peter Eisentraut) writes: > Switch from using DTRACE_PROBEn macros to the dynamically generated macros. > Use "dtrace -h" to create a header file that contains the dynamically > generated macros to be used in the source code instead of the DTRACE_PROBEn > macros. A dummy header

[COMMITTERS] pgsql: Enable probes to work with Mac OS X Leopard and other OSes that

2008-03-17 Thread Peter Eisentraut
Log Message: --- Enable probes to work with Mac OS X Leopard and other OSes that will support DTrace in the future. Switch from using DTRACE_PROBEn macros to the dynamically generated macros. Use "dtrace -h" to create a header file that contains the dynamically generated macros to be used

[COMMITTERS] pgsql: We need to rebuild objfiles.txt when one of the subdirectories'

2008-03-17 Thread Peter Eisentraut
Log Message: --- We need to rebuild objfiles.txt when one of the subdirectories' objfiles.txt changed in case a new file got added. Modified Files: -- pgsql/src/backend: common.mk (r1.6 -> r1.7) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/co

[COMMITTERS] pgsql: Add: > > o Allow Kerberos to disable stripping of realms so we

2008-03-17 Thread Bruce Momjian
Log Message: --- Add: > > o Allow Kerberos to disable stripping of realms so we can > check the [EMAIL PROTECTED] against multiple realms > > http://archives.postgresql.org/pgsql-hackers/2007-11/msg9.php Modified Files: -- pgsql/doc: TODO

[COMMITTERS] pgsql: Fix postgres --describe-config for guc enums, breakage noted by

2008-03-17 Thread Magnus Hagander
Log Message: --- Fix postgres --describe-config for guc enums, breakage noted by Alvaro. While at it, rename option lookup functions to make names clearer, per discussion with Tom. Modified Files: -- pgsql/src/backend/utils/misc: guc.c (r1.438 -> r1.439) (

[COMMITTERS] pgsql: Revert thinko introduced into prefix_selectivity() by my recent

2008-03-17 Thread Tom Lane
Log Message: --- Revert thinko introduced into prefix_selectivity() by my recent patch: make_greater_string needs the < procedure not the >= one. Spotted by Peter. Modified Files: -- pgsql/src/backend/utils/adt: selfuncs.c (r1.245 -> r1.246) (http://anoncv

Re: [COMMITTERS] pgsql: Modify interactions between sinval.c and sinvaladt.c.

2008-03-17 Thread Alvaro Herrera
Tom Lane wrote: > [EMAIL PROTECTED] (Alvaro Herrera) writes: > > Modify interactions between sinval.c and sinvaladt.c. The code that > > actually > > deals with the queue, including locking etc, is all in sinvaladt.c. This > > means > > that the struct definition of the queue, and the queue poi

[COMMITTERS] pgsql: Move ProcState definition into sinvaladt.c from sinvaladt.h,

2008-03-17 Thread Alvaro Herrera
Log Message: --- Move ProcState definition into sinvaladt.c from sinvaladt.h, since it's not needed anywhere after my previous patch. Noticed by Tom Lane. Also, remove #include from sinval.c. Modified Files: -- pgsql/src/backend/storage/ipc: sinval.c (r1.84 -> r1

[COMMITTERS] pginstaller - pginst: Update for 8.3.1

2008-03-17 Thread User Dpage
Log Message: --- Update for 8.3.1 Tags: REL8_3_STABLE Modified Files: -- pginst/package: README.TXT (r1.7 -> r1.7.2.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/package/README.TXT.diff?r1=1.7&r2=1.7.2.1) -- Sent via pgsql-commi

[COMMITTERS] pginstaller - pginst: Update for 8.3.1

2008-03-17 Thread User Dpage
Log Message: --- Update for 8.3.1 Tags: REL8_3_STABLE Modified Files: -- pginst/wxi: guid.lst (r1.43 -> r1.43.2.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/wxi/guid.lst.diff?r1=1.43&r2=1.43.2.1) -- Sent via pgsql-committers ma

[COMMITTERS] pginstaller - pginst: Update for 8.2.7

2008-03-17 Thread User Dpage
Log Message: --- Update for 8.2.7 Tags: REL8_2_STABLE Modified Files: -- pginst/package: README.TXT (r1.4.2.6 -> r1.4.2.7) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/package/README.TXT.diff?r1=1.4.2.6&r2=1.4.2.7) -- Sent via pgs