pgsql: Represent Lists as expansible arrays, not chains of cons-cells.

Represent Lists as expansible arrays, not chains of cons-cells. Originally, Postgres Lists were a more or less exact reimplementation of Lisp lists, which consist of chains of separately-allocated cons cells, each having a value and a next-cell link. We'd hacked that once before (commit d0b4399d8

pgsql: Fix pathological nbtree split point choice issue.

Fix pathological nbtree split point choice issue. Specific ever-decreasing insertion patterns could cause successive unbalanced nbtree page splits. Problem cases involve a large group of duplicates to the left, and ever-decreasing insertions to the right. To fix, detect the situation by consider

pgsql: Fix pathological nbtree split point choice issue.

Fix pathological nbtree split point choice issue. Specific ever-decreasing insertion patterns could cause successive unbalanced nbtree page splits. Problem cases involve a large group of duplicates to the left, and ever-decreasing insertions to the right. To fix, detect the situation by consider

pgsql: Correct nbtsplitloc.c comment.

Correct nbtsplitloc.c comment. The logic just added by commit e3899ffd falls back on a 50:50 page split in the event of a new item that's just to the right of our provisional "many duplicates" split point. Fix a comment that incorrectly claimed that the new item had to be just to the left of our

pgsql: Correct nbtsplitloc.c comment.

Correct nbtsplitloc.c comment. The logic just added by commit e3899ffd falls back on a 50:50 page split in the event of a new item that's just to the right of our provisional "many duplicates" split point. Fix a comment that incorrectly claimed that the new item had to be just to the left of our

pgsql: Report the time taken by pgbench initialization steps.

Report the time taken by pgbench initialization steps. Author: Fabien Coelho Reviewed-by: Ibrar Ahmed Discussion: https://postgr.es/m/alpine.DEB.2.21.1904061810510.3678%40lancre Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/ce8f946764005e1bde5a538542205e55f81bb6cc

pgsql: Provide pgbench --show-script to dump built-in scripts.

Provide pgbench --show-script to dump built-in scripts. Author: Fabien Coelho Reviewed-by: Ibrar Ahmed Discussion: https://postgr.es/m/alpine.DEB.2.21.1904081737390.5867%40lancre Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/5823677acc567d7790cc68972de12f6718913d7

pgsql: doc: mention pg_reload_conf() for reloading the config file

doc: mention pg_reload_conf() for reloading the config file Reported-by: Ian Barwick Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.4 Branch -- REL9_6_STABLE Details --- https://git.postgresql.org/pg/commitdiff/63d1bc04d1fd0b

pgsql: doc: mention pg_reload_conf() for reloading the config file

doc: mention pg_reload_conf() for reloading the config file Reported-by: Ian Barwick Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.4 Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/c6bce6ebb668c7da03d01

pgsql: doc: mention pg_reload_conf() for reloading the config file

doc: mention pg_reload_conf() for reloading the config file Reported-by: Ian Barwick Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.4 Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/d116ebca6ccc37

pgsql: doc: mention pg_reload_conf() for reloading the config file

doc: mention pg_reload_conf() for reloading the config file Reported-by: Ian Barwick Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.4 Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commitdiff/f68060cadb390a

pgsql: doc: mention pg_reload_conf() for reloading the config file

doc: mention pg_reload_conf() for reloading the config file Reported-by: Ian Barwick Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.4 Branch -- REL9_5_STABLE Details --- https://git.postgresql.org/pg/commitdiff/1944a253b3aeaa

pgsql: doc: mention pg_reload_conf() for reloading the config file

doc: mention pg_reload_conf() for reloading the config file Reported-by: Ian Barwick Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.4 Branch -- REL9_4_STABLE Details --- https://git.postgresql.org/pg/commitdiff/5dbe666ff89cf4

pgsql: doc: mention pg_reload_conf() for reloading the config file

doc: mention pg_reload_conf() for reloading the config file Reported-by: Ian Barwick Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.4 Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/commitdiff/c83067d7eac0ba

pgsql: doc: Fix Tamil language mention in PG 12 docs

doc: Fix Tamil language mention in PG 12 docs Reported-by: John Naylor Discussion: https://postgr.es/m/CACPNZCs2c7yLGKhtcL=h9OmZdwQQDshFs9Bxypo=fc5b0tv...@mail.gmail.com Backpatch-through: 12 Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/178ca6b26c3d59f

pgsql: Remove dead code.

Remove dead code. These memory context switches are useless in the wake of commit 1cff1b95a. Noted by Jesper Pedersen. Discussion: https://postgr.es/m/[email protected] Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/4c3d05d875dd173a8

pgsql: Fix inconsistencies and typos in the tree

Fix inconsistencies and typos in the tree This is numbered take 7, and addresses a set of issues around: - Fixes for typos and incorrect reference names. - Removal of unneeded comments. - Removal of unreferenced functions and structures. - Fixes regarding variable name consistency. Author: Alexan

Re: pgsql: Represent Lists as expansible arrays, not chains of cons-cells.

On Mon, Jul 15, 2019 at 05:42:09PM +, Tom Lane wrote: > Represent Lists as expansible arrays, not chains of cons-cells. crake is complaining on this one as file_textarray_fdw did not get the call: https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=crake&dt=2019-07-15 17%3A47%3A31 -- Mich