Re: [COMMITTERS] pgsql: Add psql tab completion for DO blocks.

2010-02-14 Thread Tom Lane
itag...@postgresql.org (Takahiro Itagaki) writes: > Add psql tab completion for DO blocks. > Also adjust documentation of DO. This syntax synopsis is completely nuts: DO { [ LANGUAGE lang_name ] | code } ... It implies that an empty string is a valid substitute for the { ... } construct, since

[COMMITTERS] pgstatsinfo - pg_statsinfo: Retry processing at the execute query error.

2010-02-14 Thread User Mhasegawa
Log Message: --- Retry processing at the execute query error. Add autovacuum log and checkpoint log parse. Set search_path to 'pg_catalog'. Fix some problems. Modified Files: -- pg_statsinfo/bin: autovacuum.c (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin

[COMMITTERS] pgsql: remove an unused variable 'dirfd'.

2010-02-14 Thread Takahiro Itagaki
Log Message: --- remove an unused variable 'dirfd'. Modified Files: -- pgsql/src/port: copydir.c (r1.26 -> r1.27) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/port/copydir.c?r1=1.26&r2=1.27) -- Sent via pgsql-committers mailing list (pgsql-committe

[COMMITTERS] pgsql: Add psql tab completion for DO blocks.

2010-02-14 Thread Takahiro Itagaki
Log Message: --- Add psql tab completion for DO blocks. Also adjust documentation of DO. Patch from David Fetter and subsequent discussion. Modified Files: -- pgsql/doc/src/sgml/ref: do.sgml (r1.3 -> r1.4) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/do

[COMMITTERS] pgsql: Display explain buffers measurements in memory units rather than

2010-02-14 Thread Greg Stark
Log Message: --- Display explain buffers measurements in memory units rather than blocks. Also show "Total Buffer Usage" to hint that these are totals not averages per loop Modified Files: -- pgsql/src/backend/commands: explain.c (r1.200 -> r1.201) (http:/

[COMMITTERS] reorg - pg_reorg: version 1.0.8.

2010-02-14 Thread User Itagaki
Log Message: --- version 1.0.8. Modified Files: -- pg_reorg/bin: pg_reorg.c (r1.10 -> r1.11) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/reorg/pg_reorg/bin/pg_reorg.c?r1=1.10&r2=1.11) pg_reorg/bin/pgut: pgut.c (r1.7 -> r1.8) (http://cv

[COMMITTERS] pgsql: Speed up CREATE DATABASE by deferring the fsyncs until after

2010-02-14 Thread Greg Stark
Log Message: --- Speed up CREATE DATABASE by deferring the fsyncs until after copying all the data and using posix_fadvise to nudge the OS into flushing it earlier. This also hopefully makes CREATE DATABASE avoid spamming the cache. Tests show a big speedup on Linux at least on some filesy

[COMMITTERS] pgsql: Wrap calls to SearchSysCache and related functions using macros.

2010-02-14 Thread Robert Haas
Log Message: --- Wrap calls to SearchSysCache and related functions using macros. The purpose of this change is to eliminate the need for every caller of SearchSysCache, SearchSysCacheCopy, SearchSysCacheExists, GetSysCacheOid, and SearchSysCacheList to know the maximum number of allowable

[COMMITTERS] pgsql: Make CREATE DATABASE safe against losing whole files by fsyncing

2010-02-14 Thread Greg Stark
Log Message: --- Make CREATE DATABASE safe against losing whole files by fsyncing the directory and not just the individual files. Back-patch to 8.1 -- before that we just called "cp -r" and never fsynced anything anyways. Modified Files: -- pgsql/src/port: copydir

[COMMITTERS] pgsql: Make CREATE DATABASE safe against losing whole files by fsyncing

2010-02-14 Thread Greg Stark
Log Message: --- Make CREATE DATABASE safe against losing whole files by fsyncing the directory and not just the individual files. Back-patch to 8.1 -- before that we just called "cp -r" and never fsynced anything anyways. Tags: REL8_4_STABLE Modified Files: -- pgsql

[COMMITTERS] pgsql: Make CREATE DATABASE safe against losing whole files by fsyncing

2010-02-14 Thread Greg Stark
Log Message: --- Make CREATE DATABASE safe against losing whole files by fsyncing the directory and not just the individual files. Back-patch to 8.1 -- before that we just called "cp -r" and never fsynced anything anyways. Tags: REL8_3_STABLE Modified Files: -- pgsql

[COMMITTERS] pgsql: Make CREATE DATABASE safe against losing whole files by fsyncing

2010-02-14 Thread Greg Stark
Log Message: --- Make CREATE DATABASE safe against losing whole files by fsyncing the directory and not just the individual files. Back-patch to 8.1 -- before that we just called "cp -r" and never fsynced anything anyways. Tags: REL8_2_STABLE Modified Files: -- pgsql

[COMMITTERS] pgsql: Make CREATE DATABASE safe against losing whole files by fsyncing

2010-02-14 Thread Greg Stark
Log Message: --- Make CREATE DATABASE safe against losing whole files by fsyncing the directory and not just the individual files. Back-patch to 8.1 -- before that we just called "cp -r" and never fsynced anything anyways. Tags: REL8_1_STABLE Modified Files: -- pgsql

[COMMITTERS] pgsql: Make the msvc build system ask python about details of version

2010-02-14 Thread Magnus Hagander
Log Message: --- Make the msvc build system ask python about details of version and installation prefix, instead of assuming it will always be following the default layout. All information we need is not available on Windows, but the number of assumptions are at least fewer this way than b