pgsql: Track statistics for spilling of changes from ReorderBuffer.

2019-11-20 Thread Amit Kapila
Track statistics for spilling of changes from ReorderBuffer. This adds the statistics about transactions spilled to disk from ReorderBuffer. Users can query the pg_stat_replication view to check these stats. Author: Tomas Vondra, with bug-fixes and minor changes by Dilip Kumar Reviewed-by: Amit

pgsql: Provide statistics for hypothetical BRIN indexes

2019-11-20 Thread Michael Paquier
Provide statistics for hypothetical BRIN indexes Trying to use hypothetical indexes with BRIN currently fails when trying to access a relation that does not exist when looking for the statistics. With the current API, it is not possible to easily pass a value for pages_per_range down to the hypot

pgsql: Provide statistics for hypothetical BRIN indexes

2019-11-20 Thread Michael Paquier
Provide statistics for hypothetical BRIN indexes Trying to use hypothetical indexes with BRIN currently fails when trying to access a relation that does not exist when looking for the statistics. With the current API, it is not possible to easily pass a value for pages_per_range down to the hypot

pgsql: Provide statistics for hypothetical BRIN indexes

2019-11-20 Thread Michael Paquier
Provide statistics for hypothetical BRIN indexes Trying to use hypothetical indexes with BRIN currently fails when trying to access a relation that does not exist when looking for the statistics. With the current API, it is not possible to easily pass a value for pages_per_range down to the hypot

pgsql: Provide statistics for hypothetical BRIN indexes

2019-11-20 Thread Michael Paquier
Provide statistics for hypothetical BRIN indexes Trying to use hypothetical indexes with BRIN currently fails when trying to access a relation that does not exist when looking for the statistics. With the current API, it is not possible to easily pass a value for pages_per_range down to the hypot

pgsql: Sync patternsel_common's operator selection logic with pattern_p

2019-11-20 Thread Tom Lane
Sync patternsel_common's operator selection logic with pattern_prefix's. Make patternsel_common() select the comparison operators to use with hardwired logic that matches pattern_prefix()'s new logic, eliminating its dependencies on particular index opfamilies. This shouldn't change any behavior,

pgsql: Fix HeapTupleSatisfiesNonVacuumable() comment.

2019-11-20 Thread Peter Geoghegan
Fix HeapTupleSatisfiesNonVacuumable() comment. Oversight in commit 63746189b23. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/9f0f12ac57023653ad870a33a2e0337e6f3bf512 Modified Files -- src/backend/access/heap/heapam_visibility.c | 2 +- 1 file changed,

pgsql: Reduce match_pattern_prefix()'s dependencies on index opfamilies

2019-11-20 Thread Tom Lane
Reduce match_pattern_prefix()'s dependencies on index opfamilies. Historically, the planner's LIKE/regex index optimizations were only carried out for specific index opfamilies. That's never been a great idea from the standpoint of extensibility, but it didn't matter so much as long as we had no

pgsql: Doc: improve discussion of object owners' inherent privileges.

2019-11-20 Thread Tom Lane
Doc: improve discussion of object owners' inherent privileges. In particular, clarify that the role membership mechanism allows members to inherit the ownership privileges of an object's owning role. Laurenz Albe, with some kibitzing by me Discussion: https://postgr.es/m/504497aca66bf34bdcdd90b

pgsql: Remove incorrect markup

2019-11-20 Thread Magnus Hagander
Remove incorrect markup Author: Daniel Gustafsson Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/commitdiff/d40efd2b4d592a2144d5d4edd70424f6bef2cf17 Modified Files -- doc/src/sgml/libpq.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)

pgsql: Remove incorrect markup

2019-11-20 Thread Magnus Hagander
Remove incorrect markup Author: Daniel Gustafsson Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/a28704af42c68e659cdeeec5b5b2fc84054ae02c Modified Files -- doc/src/sgml/libpq.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)

pgsql: Remove incorrect markup

2019-11-20 Thread Magnus Hagander
Remove incorrect markup Author: Daniel Gustafsson Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/2c9772f5f5b4172d7332c7fbf742d773bdf44e1c Modified Files -- doc/src/sgml/libpq.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)

pgsql: Remove incorrect markup

2019-11-20 Thread Magnus Hagander
Remove incorrect markup Author: Daniel Gustafsson Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commitdiff/a45feb1a4fd48dad5d969d1ff010861a18b4a6b9 Modified Files -- doc/src/sgml/libpq.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)

pgsql: Remove incorrect markup

2019-11-20 Thread Magnus Hagander
Remove incorrect markup Author: Daniel Gustafsson Branch -- REL9_5_STABLE Details --- https://git.postgresql.org/pg/commitdiff/31d3da740cf888b7d59ab7ea82e329fe536a38d6 Modified Files -- doc/src/sgml/libpq.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)

pgsql: Remove incorrect markup

2019-11-20 Thread Magnus Hagander
Remove incorrect markup Author: Daniel Gustafsson Branch -- REL9_4_STABLE Details --- https://git.postgresql.org/pg/commitdiff/d81d4c36ac98a7b402c14581c278273e9063ff0a Modified Files -- doc/src/sgml/libpq.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)

pgsql: Fix comment in xact.h

2019-11-20 Thread Michael Paquier
Fix comment in xact.h xl_xact_relfilenodes refers to a number of relations, not XIDs, whose relfilenodes are processed. Author: Yu Kimura Discussion: https://postgr.es/m/[email protected] Branch -- master Details --- https://git.postgresql.org/pg/commitdif