[COMMITTERS] pgsql: Add an 'enable_material' GUC.

2010-04-18 Thread Robert Haas
Log Message: --- Add an 'enable_material' GUC. The logic for determining whether to materialize has been significantly overhauled for 9.0. In case there should be any doubt about whether materialization is a win in any particular case, this should provide a convenient way of seeing what h

[COMMITTERS] pgsql: Provide better guidance for adjusting shared_buffers.

2010-04-18 Thread Robert Haas
Log Message: --- Provide better guidance for adjusting shared_buffers. This change was previously committed to HEAD, but the consensus seems to be in favor of back-patching it. I'm only backpatching as far as 8.3.X, however, because it's not clear to me to what degree this advice applies

[COMMITTERS] pgsql: Provide better guidance for adjusting shared_buffers.

2010-04-18 Thread Robert Haas
Log Message: --- Provide better guidance for adjusting shared_buffers. This change was previously committed to HEAD, but the consensus seems to be in favor of back-patching it. I'm only backpatching as far as 8.3.X, however, because it's not clear to me to what degree this advice applies

[COMMITTERS] pgsql: Fix bogus order of cleanup steps in plperl_inline_handler.

2010-04-18 Thread Tom Lane
Log Message: --- Fix bogus order of cleanup steps in plperl_inline_handler. Per Alex Hunsaker Modified Files: -- pgsql/src/pl/plperl: plperl.c (r1.173 -> r1.174) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/pl/plperl/plperl.c?r1=1.173&r2=1.174) --

[COMMITTERS] pgsql: Improve sequence and sense of messages from pg_stop_backup().

2010-04-18 Thread Simon Riggs
Log Message: --- Improve sequence and sense of messages from pg_stop_backup(). Now doesn't report it is waiting until it actually is waiting, plus message doesn't appear until at least 5 seconds wait, so we avoid reporting the wait before we've given the archiver a reasonable time to wake u

[COMMITTERS] pgsql: Remove some additional changes in previous commit that belong

2010-04-18 Thread Simon Riggs
Log Message: --- Remove some additional changes in previous commit that belong elsewhere. Modified Files: -- pgsql/src/backend/access/transam: xlog.c (r1.398 -> r1.399) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/xlog.c?r1=1.3

[COMMITTERS] pgsql: Tune GetSnapshotData() during Hot Standby by avoiding loop

2010-04-18 Thread Simon Riggs
Log Message: --- Tune GetSnapshotData() during Hot Standby by avoiding loop through normal backends. Makes code clearer also, since we avoid various Assert()s. Performance of snapshots taken during recovery no longer depends upon number of read-only backends. Modified Files: --