pgsql: Propagate ALTER TABLE ... SET STORAGE to indexes

2020-05-07 Thread Peter Eisentraut
Propagate ALTER TABLE ... SET STORAGE to indexes When creating a new index, the attstorage setting of the table column is copied to regular (non-expression) index columns. But a later ALTER TABLE ... SET STORAGE is not propagated to indexes, thus creating an inconsistent and undumpable state. Di

pgsql: Fix inconsistency in pg_buffercache docs.

2020-05-07 Thread Amit Kapila
Fix inconsistency in pg_buffercache docs. Commit 6e654546fb avoids locking bufmgr partitions to make pg_buffercache less disruptive on production systems but forgot to update the docs. Reported-by: Sawada Masahiko Author: Sawada Masahiko Reviewed-by: Amit Kapila Backpatch-through: 10 Discussion:

pgsql: Fix inconsistency in pg_buffercache docs.

2020-05-07 Thread Amit Kapila
Fix inconsistency in pg_buffercache docs. Commit 6e654546fb avoids locking bufmgr partitions to make pg_buffercache less disruptive on production systems but forgot to update the docs. Reported-by: Sawada Masahiko Author: Sawada Masahiko Reviewed-by: Amit Kapila Backpatch-through: 10 Discussion:

pgsql: Fix inconsistency in pg_buffercache docs.

2020-05-07 Thread Amit Kapila
Fix inconsistency in pg_buffercache docs. Commit 6e654546fb avoids locking bufmgr partitions to make pg_buffercache less disruptive on production systems but forgot to update the docs. Reported-by: Sawada Masahiko Author: Sawada Masahiko Reviewed-by: Amit Kapila Backpatch-through: 10 Discussion:

pgsql: Fix inconsistency in pg_buffercache docs.

2020-05-07 Thread Amit Kapila
Fix inconsistency in pg_buffercache docs. Commit 6e654546fb avoids locking bufmgr partitions to make pg_buffercache less disruptive on production systems but forgot to update the docs. Reported-by: Sawada Masahiko Author: Sawada Masahiko Reviewed-by: Amit Kapila Backpatch-through: 10 Discussion:

pgsql: Report missing wait event for timeline history file.

2020-05-07 Thread Fujii Masao
Report missing wait event for timeline history file. TimelineHistoryRead and TimelineHistoryWrite wait events are reported during waiting for a read and write of a timeline history file, respectively. However, previously, TimelineHistoryRead wait event was not reported while readTimeLineHistory()

pgsql: Report missing wait event for timeline history file.

2020-05-07 Thread Fujii Masao
Report missing wait event for timeline history file. TimelineHistoryRead and TimelineHistoryWrite wait events are reported during waiting for a read and write of a timeline history file, respectively. However, previously, TimelineHistoryRead wait event was not reported while readTimeLineHistory()

pgsql: Report missing wait event for timeline history file.

2020-05-07 Thread Fujii Masao
Report missing wait event for timeline history file. TimelineHistoryRead and TimelineHistoryWrite wait events are reported during waiting for a read and write of a timeline history file, respectively. However, previously, TimelineHistoryRead wait event was not reported while readTimeLineHistory()

pgsql: Report missing wait event for timeline history file.

2020-05-07 Thread Fujii Masao
Report missing wait event for timeline history file. TimelineHistoryRead and TimelineHistoryWrite wait events are reported during waiting for a read and write of a timeline history file, respectively. However, previously, TimelineHistoryRead wait event was not reported while readTimeLineHistory()

pgsql: Refactor nbtree deletion INCOMPLETE_SPLIT check.

2020-05-07 Thread Peter Geoghegan
Refactor nbtree deletion INCOMPLETE_SPLIT check. Factor out code common to _bt_lock_branch_parent() and _bt_pagedel() into a new utility function. This new function is used to check that the left sibling of a deletion target page does not have the INCOMPLETE_SPLIT page flag set. If it is set the

pgsql: Fix YA text phrase search bug.

2020-05-07 Thread Tom Lane
Fix YA text phrase search bug. checkcondition_str() failed to report multiple matches for a prefix pattern correctly: it would dutifully merge the match positions, but then after exiting that loop, if the last prefix-matching word had had no suitable positions, it would report there were no matche

pgsql: Fix YA text phrase search bug.

2020-05-07 Thread Tom Lane
Fix YA text phrase search bug. checkcondition_str() failed to report multiple matches for a prefix pattern correctly: it would dutifully merge the match positions, but then after exiting that loop, if the last prefix-matching word had had no suitable positions, it would report there were no matche

pgsql: Fix YA text phrase search bug.

2020-05-07 Thread Tom Lane
Fix YA text phrase search bug. checkcondition_str() failed to report multiple matches for a prefix pattern correctly: it would dutifully merge the match positions, but then after exiting that loop, if the last prefix-matching word had had no suitable positions, it would report there were no matche

pgsql: Fix YA text phrase search bug.

2020-05-07 Thread Tom Lane
Fix YA text phrase search bug. checkcondition_str() failed to report multiple matches for a prefix pattern correctly: it would dutifully merge the match positions, but then after exiting that loop, if the last prefix-matching word had had no suitable positions, it would report there were no matche

pgsql: Fix YA text phrase search bug.

2020-05-07 Thread Tom Lane
Fix YA text phrase search bug. checkcondition_str() failed to report multiple matches for a prefix pattern correctly: it would dutifully merge the match positions, but then after exiting that loop, if the last prefix-matching word had had no suitable positions, it would report there were no matche

pgsql: Doc: update remaining tables of functions/operators for new layo

2020-05-07 Thread Tom Lane
Doc: update remaining tables of functions/operators for new layout. This converts the contrib documentation to the new style, and mops up a couple of function tables that were outside chapter 9 in the main docs. A few contrib modules choose not to present their functions in the standard tabular f

pgsql: doc: PG 13 relnotes: adjust partitioning items

2020-05-07 Thread Bruce Momjian
doc: PG 13 relnotes: adjust partitioning items Reported-by: Amit Langote Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/c265ed9b355fdd2a80e7af64e88cddabd3d39151 Modified Files -- doc/src/sgml/release-13.sgml | 11 +-- 1 file changed, 9 insertion

pgsql: doc: PG 13 relnotes: adjust wording and Unicode item

2020-05-07 Thread Bruce Momjian
doc: PG 13 relnotes: adjust wording and Unicode item Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/db9e99da2c61f46bfe37032bab1ee602e5c8335c Modified Files -- doc/src/sgml/release-13.sgml | 10 +++--- 1 file changed, 3 insertions(+), 7 deletions(-)

pgsql: doc: PG 13 relnotes: adjust partition items and attributions

2020-05-07 Thread Bruce Momjian
doc: PG 13 relnotes: adjust partition items and attributions This merges three partition publication items into two. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/545a065880be8ccddfb116a0915bfdac0cd41902 Modified Files -- doc/src/sgml/release-13.sgm