[COMMITTERS] pgsql: Mention in the docs that bgwriter now sleeps longer when it has

Mention in the docs that bgwriter now sleeps longer when it has no work to do. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/2e92b5872faeb01f1865bb00556ec7be0ef006ee Modified Files -- doc/src/sgml/config.sgml | 14 -- 1 files changed, 8 ins

[COMMITTERS] pgsql: Fix pg_upgrade --help text for --user to not use a plural cluste

Fix pg_upgrade --help text for --user to not use a plural cluster name. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/3946c281613e549d5686ad3f5b298549b0eb0efe Modified Files -- contrib/pg_upgrade/option.c |2 +- 1 files changed, 1 insertions(+), 1 de

[COMMITTERS] pgsql: Adjust tuplesort.c based on the fact that we never use the OS's

Adjust tuplesort.c based on the fact that we never use the OS's qsort(). Our own qsort_arg() implementation doesn't have the defect previously observed to affect only QNX 4, so it seems sufficiently to assert that it isn't broken rather than retesting. Also, update a few comments to clarify why i

[COMMITTERS] pgsql: Be more clear when a new column name collides with a system colu

Be more clear when a new column name collides with a system column name. We now use the same error message for ALTER TABLE .. ADD COLUMN or ALTER TABLE .. RENAME COLUMN that we do for CREATE TABLE. The old message was accurate, but might be confusing to users not aware of our system columns. Vik

[COMMITTERS] pgsql: Fix sentence in docs: checkpoints are not done by bgwriter anymo

Fix sentence in docs: checkpoints are not done by bgwriter anymore. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/d4bad4e1e1c7269b906f3b005fc322537630efcf Modified Files -- doc/src/sgml/wal.sgml |2 +- 1 files changed, 1 insertions(+), 1 deletions(-)

[COMMITTERS] pgsql: Make bgwriter sleep longer when it has no work to do, to save el

Make bgwriter sleep longer when it has no work to do, to save electricity. To make it wake up promptly when activity starts again, backends nudge it by setting a latch in MarkBufferDirty(). The latch is kept set while bgwriter is active, so there is very little overhead from that when the system i

[COMMITTERS] pgsql: Add missing #include, to suppress compiler warning.

Add missing #include, to suppress compiler warning. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/467ff207f51439cadee7857d6a0874f34652ed53 Modified Files -- src/backend/storage/file/fd.c |1 + 1 files changed, 1 insertions(+), 0 deletions(-) -- Se

[COMMITTERS] pgsql: Fix a copy/pasted typo in several comments

Fix a copy/pasted typo in several comments Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/7729e22d83b31afa1009f190bf0f4838cc8feaf8 Modified Files -- src/backend/postmaster/pgstat.c |6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) -- Sent

[COMMITTERS] pgsql: Add deadlock counter to pg_stat_database

Add deadlock counter to pg_stat_database Adds a counter that tracks number of deadlocks that occurred in each database to pg_stat_database. Magnus Hagander, reviewed by Jaime Casanova Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/61cb8c5abb9235c3106af6c6a6e60d94cb

[COMMITTERS] pgsql: Classify DROP operations by whether or not they are user-initiat

Classify DROP operations by whether or not they are user-initiated. This doesn't do anything useful just yet, but is intended as supporting infrastructure for allowing sepgsql to sensibly check DROP permissions. KaiGai Kohei and Robert Haas Branch -- master Details --- http://git.postgr

[COMMITTERS] pgsql: Track temporary file count and size in pg_stat_database

Track temporary file count and size in pg_stat_database Add counters for number and size of temporary files used for spill-to-disk queries for each database to the pg_stat_database view. Tomas Vondra, review by Magnus Hagander Branch -- master Details --- http://git.postgresql.org/pg/co

[COMMITTERS] pgsql: Damage control for yesterday's CheckIndexCompatible changes.

Damage control for yesterday's CheckIndexCompatible changes. Rip out a regression test that doesn't play well with settings put in place by the build farm, and rewrite the code in CheckIndexCompatible in a hopefully more transparent style. Branch -- master Details --- http://git.postgres