pgsql: doc: Correct description of restart_lsn in pg_replication_slots

2020-07-02 Thread Fujii Masao
doc: Correct description of restart_lsn in pg_replication_slots Previously the document explained that restart_lsn indicates the LSN of oldest WAL won't be automatically removed during checkpoints. But since v13 this was no longer true thanks to max_slot_wal_keep_size. Back-patch to v13 where max

pgsql: doc: Correct description of restart_lsn in pg_replication_slots

2020-07-02 Thread Fujii Masao
doc: Correct description of restart_lsn in pg_replication_slots Previously the document explained that restart_lsn indicates the LSN of oldest WAL won't be automatically removed during checkpoints. But since v13 this was no longer true thanks to max_slot_wal_keep_size. Back-patch to v13 where max

pgsql: Change default of pg_stat_statements.track_planning to off.

2020-07-02 Thread Fujii Masao
Change default of pg_stat_statements.track_planning to off. Since v13 pg_stat_statements is allowed to track the planning time of statements when track_planning option is enabled. Its default was on. But this feature could cause more terrible spinlock contentions in pg_stat_statements. As a resul

pgsql: Change default of pg_stat_statements.track_planning to off.

2020-07-02 Thread Fujii Masao
Change default of pg_stat_statements.track_planning to off. Since v13 pg_stat_statements is allowed to track the planning time of statements when track_planning option is enabled. Its default was on. But this feature could cause more terrible spinlock contentions in pg_stat_statements. As a resul

pgsql: Initialize work_mem using current guc.c default.

2020-07-02 Thread Peter Geoghegan
Initialize work_mem using current guc.c default. Do the same for the maintenance_work_mem global variable. Oversight in commit 848ae330a49, which increased the previous defaults for work_mem and maintenance_work_mem by 4X. Branch -- master Details --- https://git.postgresql.org/pg/commi

pgsql: nbtree: Rename _bt_search() variables.

2020-07-02 Thread Peter Geoghegan
nbtree: Rename _bt_search() variables. Make some of the variable names in _bt_search() consistent with corresponding variables within _bt_getstackbuf(). This naming scheme is clearer because the variable names always express a relationship between the currently locked buffer/page and some other p