[COMMITTERS] pgsql: Temporarily modify tsearch regression tests to suppress notice

2007-09-23 Thread Tom Lane
Log Message: --- Temporarily modify tsearch regression tests to suppress notice that comes out at erratic times, because it is creating a totally unacceptable level of noise in our buildfarm results. This patch can be reverted when and if the code is fixed to not issue notices during cache

[COMMITTERS] pgsql: Typo fix from Brendan Jurd.

2007-09-23 Thread Bruce Momjian
Log Message: --- Typo fix from Brendan Jurd. Modified Files: -- pgsql/doc: FAQ_DEV (r1.141 -> r1.142) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/FAQ_DEV?r1=1.141&r2=1.142) pgsql/doc/src/FAQ: FAQ_DEV.html (r1.145 -> r1.146) (h

[COMMITTERS] pgsql: TransactionIdIsInProgress can skip scanning the ProcArray if the

2007-09-23 Thread Tom Lane
Log Message: --- TransactionIdIsInProgress can skip scanning the ProcArray if the target XID is later than latestCompletedXid, per Florian Pflug. Also some minor improvements in the XIDCACHE_DEBUG code --- make sure each call of TransactionIdIsInProgress is counted one way or another. Mod

[COMMITTERS] pgsql: Make autovacuum report the start time of its current activity in

2007-09-23 Thread Tom Lane
Log Message: --- Make autovacuum report the start time of its current activity in pg_stat_activity. Per gripe from Jim Nasby. Modified Files: -- pgsql/src/backend/postmaster: autovacuum.c (r1.58 -> r1.59) (http://developer.postgresql.org/cvsweb.cgi/pgsql/s

[COMMITTERS] pgsql: Restrict overly broad searches, and fix typo, in recent fix.

2007-09-23 Thread Andrew Dunstan
Log Message: --- Restrict overly broad searches, and fix typo, in recent fix. Per Hannes Eder. Modified Files: -- pgsql/src/tools/msvc: Install.pm (r1.20 -> r1.21) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/tools/msvc/Install.pm?r1=1.20&r2=1.21)

[COMMITTERS] pgsql: Fix bugs in XML binary I/O functions.

2007-09-23 Thread Tom Lane
Log Message: --- Fix bugs in XML binary I/O functions. Heikki and Tom Modified Files: -- pgsql/src/backend/utils/adt: xml.c (r1.46 -> r1.47) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/xml.c?r1=1.46&r2=1.47) ---

[COMMITTERS] pgsql: Add perl replacements for build.bat and vcregress.bat.

2007-09-23 Thread Andrew Dunstan
Log Message: --- Add perl replacements for build.bat and vcregress.bat. In due course the .bat files will be altered to become tiny wrappers for these scripts, and one or two other .bat files will disappear. Added Files: --- pgsql/src/tools/msvc: build.pl (r1.1)

[COMMITTERS] pgsql: Replace linear searches with binary searches in pg_dump's code to

2007-09-23 Thread Tom Lane
Log Message: --- Replace linear searches with binary searches in pg_dump's code to lookup objects by OID. Per gripe from nikitathespider. Modified Files: -- pgsql/src/bin/pg_dump: common.c (r1.97 -> r1.98) (http://developer.postgresql.org/cvsweb.cgi/pgsql/

[COMMITTERS] pgsql: Remove "convert 'blah' using conversion_name" facility, because

2007-09-23 Thread Andrew Dunstan
Log Message: --- Remove "convert 'blah' using conversion_name" facility, because if it produces text it is an encoding hole and if not it's incompatible with the spec, whatever the spec means (which we're not sure about anyway). Modified Files: -- pgsql/doc/src/sgml:

[COMMITTERS] pgsql: Simplify and rename some GUC variables, per various recent

2007-09-23 Thread Tom Lane
Log Message: --- Simplify and rename some GUC variables, per various recent discussions: * stats_start_collector goes away; we always start the collector process, unless prevented by a problem with setting up the stats UDP socket. * stats_reset_on_server_start goes away; it seems useless

Re: [COMMITTERS] pgsql: Remove "convert 'blah' using conversion_name" facility, because

2007-09-23 Thread Tom Lane
[EMAIL PROTECTED] (Andrew Dunstan) writes: > Remove "convert 'blah' using conversion_name" facility, because if it > produces text it is an encoding hole and if not it's incompatible > with the spec, whatever the spec means (which we're not sure about anyway). It's not critical, but just for futur

[COMMITTERS] pgsql: Reduce the size of memory allocations by lazy vacuum when

2007-09-23 Thread Alvaro Herrera
Log Message: --- Reduce the size of memory allocations by lazy vacuum when processing a small table, by allocating just enough for a hardcoded number of dead tuples per page. The current estimate is 200 dead tuples per page. Per reports from Jeff Amiel, Erik Jones and Marko Kreen, and sub

[COMMITTERS] pgsql: Reduce the size of memory allocations by lazy vacuum when

2007-09-23 Thread Alvaro Herrera
Log Message: --- Reduce the size of memory allocations by lazy vacuum when processing a small table, by allocating just enough for a hardcoded number of dead tuples per page. The current estimate is 200 dead tuples per page. Per reports from Jeff Amiel, Erik Jones and Marko Kreen, and sub

[COMMITTERS] pgsql: Reduce the size of memory allocations by lazy vacuum when

2007-09-23 Thread Alvaro Herrera
Log Message: --- Reduce the size of memory allocations by lazy vacuum when processing a small table, by allocating just enough for a hardcoded number of dead tuples per page. The current estimate is 200 dead tuples per page. Per reports from Jeff Amiel, Erik Jones and Marko Kreen, and sub

[COMMITTERS] pgsql: Reduce the size of memory allocations by lazy vacuum when

2007-09-23 Thread Alvaro Herrera
Log Message: --- Reduce the size of memory allocations by lazy vacuum when processing a small table, by allocating just enough for a hardcoded number of dead tuples per page. The current estimate is 200 dead tuples per page. Per reports from Jeff Amiel, Erik Jones and Marko Kreen, and sub

Re: [COMMITTERS] pgsql: Remove "convert 'blah' using conversion_name" facility, because

2007-09-23 Thread Andrew Dunstan
Tom Lane wrote: [EMAIL PROTECTED] (Andrew Dunstan) writes: Remove "convert 'blah' using conversion_name" facility, because if it produces text it is an encoding hole and if not it's incompatible with the spec, whatever the spec means (which we're not sure about anyway). It's not crit

[COMMITTERS] pgsql: Avoid having autovacuum read pgstats data too many times in quick

2007-09-23 Thread Alvaro Herrera
Log Message: --- Avoid having autovacuum read pgstats data too many times in quick succession. This is problematic for the autovac launcher when there are many databases, so we keep data for a full second before reading it again. Modified Files: -- pgsql/src/backend/postmas