[COMMITTERS] pgsql: Move pg_stat_progress_vacuum to the table of Dynamic Statistics

2017-04-12 Thread Fujii Masao
Move pg_stat_progress_vacuum to the table of Dynamic Statistics Views in doc. Previously the description about pg_stat_progress_vacuum was in the table of "Collected Statistics Views" in the doc. But since it repors dynamic information, i.e., the current progress of VACUUM, its description should

[COMMITTERS] pgsql: Move pg_stat_progress_vacuum to the table of Dynamic Statistics

2017-04-12 Thread Fujii Masao
Move pg_stat_progress_vacuum to the table of Dynamic Statistics Views in doc. Previously the description about pg_stat_progress_vacuum was in the table of "Collected Statistics Views" in the doc. But since it repors dynamic information, i.e., the current progress of VACUUM, its description should

[COMMITTERS] pgsql: Improve documentations for ALTER PUBLICATION and ALTER SUBSCRIPT

2017-04-12 Thread Fujii Masao
Improve documentations for ALTER PUBLICATION and ALTER SUBSCRIPTION. Discussion: http://postgr.es/m/cad21aoc32ygtatenqtfxztjmhhe6hxs4cpjtnd3n-ts8f-a...@mail.gmail.com Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/a6e7d591d0129bc7f1f186cb40a6ebd7963956ab Modified

[COMMITTERS] pgsql: Improve tab-completion of DDL for publication and subscription.

2017-04-12 Thread Fujii Masao
Improve tab-completion of DDL for publication and subscription. Author: Masahiko Sawada Discussion: http://postgr.es/m/cad21aoc32ygtatenqtfxztjmhhe6hxs4cpjtnd3n-ts8f-a...@mail.gmail.com Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/c525f740661104e3d8578a133ed6b4a8

[COMMITTERS] pgsql: Speed up hash_index regression test.

2017-04-12 Thread Tom Lane
Speed up hash_index regression test. Commit f5ab0a14e made this test take substantially longer than it used to. With a bit more care, we can get the runtime back down while achieving the same, or even a bit better, code coverage. Mithun Cy Discussion: https://postgr.es/m/cad__ouh-qaeb+rd7uy-4g

[COMMITTERS] pgsql: Avoid transferring parallel-unsafe subplans to parallel workers.

2017-04-12 Thread Tom Lane
Avoid transferring parallel-unsafe subplans to parallel workers. Commit 5e6d8d2bb allowed parallel workers to execute parallel-safe subplans, but it transmitted the query's entire list of subplans to the worker(s). Since execMain.c blindly does ExecInitNode and later ExecEndNode on every list ele

[COMMITTERS] pgsql: doc: Tweak CSS

2017-04-12 Thread Peter Eisentraut
doc: Tweak CSS Tweak CSS a bit to match latest similar changes to web site style. Also move some CSS out of the HTML to the stylesheet so that the web site stylesheet can override it. This should ensure that notes and such are back to being centered. Branch -- master Details --- http:/

[COMMITTERS] pgsql: git_changelog: improve instructions for finding branch commits

2017-04-12 Thread Bruce Momjian
git_changelog: improve instructions for finding branch commits Specifically, use '--summary' with 'git show'. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/854854019a282b6e74f586a3ee8c88c791193d32 Modified Files -- src/tools/git_changelog | 2 +- 1 fil

[COMMITTERS] pgsql: Mark finished Plan nodes with parallel_safe flags.

2017-04-12 Thread Tom Lane
Mark finished Plan nodes with parallel_safe flags. We'd managed to avoid doing this so far, but it seems pretty obvious that it would be forced on us some day, and this is much the cleanest way of approaching the open problem that parallel-unsafe subplans are being transmitted to parallel workers.

[COMMITTERS] pgsql: Remove some tabs in SQL code in C string literals

2017-04-12 Thread Peter Eisentraut
Remove some tabs in SQL code in C string literals This is not handled uniformly throughout the code, but at least nearby code can be consistent. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/35b5f7b608fa1ae12d07cd475c382c5f1341648d Modified Files -- sr

[COMMITTERS] pgsql: Fix pgstattuple's handling of unused hash pages.

2017-04-12 Thread Robert Haas
Fix pgstattuple's handling of unused hash pages. Hash indexes can contain both pages which are all-zeroes (i.e. PageIsNew()) and pages which have been initialized but currently aren't used. The latter category can happen either when a page has been reserved but not yet used or when it is used for

[COMMITTERS] pgsql: Code review for c94e6942cefe7d20c5feed856e27f672734b1e2b.

2017-04-12 Thread Robert Haas
Code review for c94e6942cefe7d20c5feed856e27f672734b1e2b. validateCheckConstraint() shouldn't try to access the storage for a partitioned table, because it no longer has any. Creating a _RETURN table on a partitioned table shouldn't be allowed, both because there's no value in it and because tryi

[COMMITTERS] pgsql: Fix reversed check of return value from sync

2017-04-12 Thread Magnus Hagander
Fix reversed check of return value from sync While at it also update the comments in walmethods.h to make it less likely for mistakes like this to appear in the future (thanks to Tom for improvements to the comments). And finally, in passing change the return type of walmethod.getlasterror to bei