[COMMITTERS] pgsql: In the integer-datetimes case, date2timestamp and

2007-09-25 Thread Tom Lane
Log Message: --- In the integer-datetimes case, date2timestamp and date2timestamptz need to check for overflow because the legal range of type date is actually wider than timestamp's. Problem found by Neil Conway. Modified Files: -- pgsql/src/backend/utils/adt: dat

[COMMITTERS] pgsql: Use SYSV semaphores rather than POSIX on Darwin >= 6.0 (i.e., OS

2007-09-25 Thread Tom Lane
Log Message: --- Use SYSV semaphores rather than POSIX on Darwin >= 6.0 (i.e., OS X 10.2 and up), per Chris Marcellino. This avoids consuming O(N^2) file descriptors to support N backends. Tests suggest it's about a wash for small installations, but large ones would have a problem. Modif

[COMMITTERS] pgsql: Change on-disk representation of NUMERIC datatype so that the

2007-09-25 Thread Tom Lane
Log Message: --- Change on-disk representation of NUMERIC datatype so that the sign_dscale word comes before the weight instead of after. This will allow future binary-compatible extension of the representation to support compact formats, as discussed on pgsql-hackers around 2007/06/18. T

[COMMITTERS] pgsql: Dept.

2007-09-25 Thread Tom Lane
Log Message: --- Dept. of second thoughts: fix loop in BgBufferSync so that the exit when bgwriter_lru_maxpages is exceeded leaves the loop variables in the expected state. In the original coding, we'd fail to advance next_to_clean, causing that buffer to be probably-uselessly rechecked ne

[COMMITTERS] pgsql: Just-in-time background writing strategy.

2007-09-25 Thread Tom Lane
Log Message: --- Just-in-time background writing strategy. This code avoids re-scanning buffers that cannot possibly need to be cleaned, and estimates how many buffers it should try to clean based on moving averages of recent allocation requests and density of reusable buffers. The patch

[COMMITTERS] pgsql: Small string tweaks

2007-09-25 Thread Peter Eisentraut
Log Message: --- Small string tweaks Modified Files: -- pgsql/src/bin/initdb: initdb.c (r1.140 -> r1.141) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/initdb/initdb.c?r1=1.140&r2=1.141) pgsql/src/bin/pg_ctl: pg_ctl.c (r1.83 -> r1.84

[COMMITTERS] stackbuilder - installers: Update for Slony 1.2.11

2007-09-25 Thread User Dpage
Log Message: --- Update for Slony 1.2.11 Modified Files: -- installers/Slony_I_PG83: Config.bat (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/stackbuilder/installers/Slony_I_PG83/Config.bat.diff?r1=1.1&r2=1.2) guid.cache (r1.1 -> r1.2)

[COMMITTERS] stackbuilder - installers: Update for Slony 1.2.11

2007-09-25 Thread User Dpage
Log Message: --- Update for Slony 1.2.11 Modified Files: -- installers/Slony_I_PG82: Config.bat (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/stackbuilder/installers/Slony_I_PG82/Config.bat.diff?r1=1.1&r2=1.2) ---(end

[COMMITTERS] stackbuilder - setupkit: Dept.

2007-09-25 Thread User Dpage
Log Message: --- Dept. of second thoughts. After discussion with Magnus, leave the versioned filenames on the server and have the wizard rename them to their package IDs. This saves having constraints on the naming scheme and storage structure used by any of the application publishers.

[COMMITTERS] stackbuilder - wizard: Dept.

2007-09-25 Thread User Dpage
Log Message: --- Dept. of second thoughts. After discussion with Magnus, leave the versioned filenames on the server and have the wizard rename them to their package IDs. This saves having constraints on the naming scheme and storage structure used by any of the application publishers.

[COMMITTERS] pgcheck - pokus: Identification of faulty blocks in indexes added.

2007-09-25 Thread User Machr2
Log Message: --- Identification of faulty blocks in indexes added. Some bugs removed Modified Files: -- pokus/src: pgcheck_index_full.c (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgcheck/pokus/src/pgcheck_index_full.c.diff?r1=1.2&r2=1.3) -