[COMMITTERS] pgsql: Test parallel query essentials in "make check".

2016-06-07 Thread Noah Misch
Test parallel query essentials in "make check". Clément Prévost and Peter Eisentraut Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/14a254fb52423c57059851abafbd1247261f7f03 Modified Files -- src/test/regress/expected/select_parallel.out | 54 +++

[COMMITTERS] pgsql: Make psql_crosstab plans more stable

2016-06-07 Thread Alvaro Herrera
Make psql_crosstab plans more stable To achieve this, ANALYZE the data table before querying it, as suggested by Tom Lane. On my system, this enables the test to pass with 128 kB of work_mem (a value with which other tests fail -- so it seems good enough). Reported by Michaël Paquier. Branch --

[COMMITTERS] pgsql: nls-global.mk: search build dir for source files, too

2016-06-07 Thread Alvaro Herrera
nls-global.mk: search build dir for source files, too In VPATH builds, the build directory was not being searched for files in GETTEXT_FILES, leading to failure to construct the .pot files. This has bit me all along, but never hard enough to get it fixed; I suppose not a lot of people uses VPATH

[COMMITTERS] pgsql: nls-global.mk: search build dir for source files, too

2016-06-07 Thread Alvaro Herrera
nls-global.mk: search build dir for source files, too In VPATH builds, the build directory was not being searched for files in GETTEXT_FILES, leading to failure to construct the .pot files. This has bit me all along, but never hard enough to get it fixed; I suppose not a lot of people uses VPATH

[COMMITTERS] pgsql: nls-global.mk: search build dir for source files, too

2016-06-07 Thread Alvaro Herrera
nls-global.mk: search build dir for source files, too In VPATH builds, the build directory was not being searched for files in GETTEXT_FILES, leading to failure to construct the .pot files. This has bit me all along, but never hard enough to get it fixed; I suppose not a lot of people uses VPATH

[COMMITTERS] pgsql: nls-global.mk: search build dir for source files, too

2016-06-07 Thread Alvaro Herrera
nls-global.mk: search build dir for source files, too In VPATH builds, the build directory was not being searched for files in GETTEXT_FILES, leading to failure to construct the .pot files. This has bit me all along, but never hard enough to get it fixed; I suppose not a lot of people uses VPATH

[COMMITTERS] pgsql: nls-global.mk: search build dir for source files, too

2016-06-07 Thread Alvaro Herrera
nls-global.mk: search build dir for source files, too In VPATH builds, the build directory was not being searched for files in GETTEXT_FILES, leading to failure to construct the .pot files. This has bit me all along, but never hard enough to get it fixed; I suppose not a lot of people uses VPATH

[COMMITTERS] pgsql: nls-global.mk: search build dir for source files, too

2016-06-07 Thread Alvaro Herrera
nls-global.mk: search build dir for source files, too In VPATH builds, the build directory was not being searched for files in GETTEXT_FILES, leading to failure to construct the .pot files. This has bit me all along, but never hard enough to get it fixed; I suppose not a lot of people uses VPATH

[COMMITTERS] pgsql: Fix thinko in description of table_name parameter

2016-06-07 Thread Alvaro Herrera
Fix thinko in description of table_name parameter Commit 6820094d1 mixed up types of parent object (table) with type of sub-object being commented on. Noticed while fixing docs for COMMENT ON ACCESS METHOD. Backpatch to 9.5, like that commit. Branch -- master Details --- http://git.pos

[COMMITTERS] pgsql: Fix thinko in description of table_name parameter

2016-06-07 Thread Alvaro Herrera
Fix thinko in description of table_name parameter Commit 6820094d1 mixed up types of parent object (table) with type of sub-object being commented on. Noticed while fixing docs for COMMENT ON ACCESS METHOD. Backpatch to 9.5, like that commit. Branch -- REL9_5_STABLE Details --- http://

[COMMITTERS] pgsql: Add missing translate_columns array entry

2016-06-07 Thread Alvaro Herrera
Add missing translate_columns array entry This omission caused an assertion error in \dA+. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/8b3746208ce2a2a2bb057dec09cf09a0c783d91b Modified Files -- src/bin/psql/describe.c | 2 +- 1 file changed, 1 inserti

[COMMITTERS] pgsql: Fix loose ends for SQL ACCESS METHOD objects

2016-06-07 Thread Alvaro Herrera
Fix loose ends for SQL ACCESS METHOD objects COMMENT ON ACCESS METHOD was missing; add it, along psql tab-completion support for it. psql was also missing a way to list existing access methods; the new \dA command does that. Also add tab-completion support for DROP ACCESS METHOD. Author: Michae

[COMMITTERS] pgsql: Revert "Use Foreign Key relationships to infer multi-column join

2016-06-07 Thread Tom Lane
Revert "Use Foreign Key relationships to infer multi-column join selectivity". This commit reverts 137805f89 as well as the associated commits 015e88942, 5306df283, and 68d704edb. We found multiple bugs in this feature, and there was concern about possible planner slowdown (though to be fair, exh

[COMMITTERS] pgsql: doc: Fix typo

2016-06-07 Thread Peter Eisentraut
doc: Fix typo Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/79616ae73b0ba2fb650a9d8ebc5ce8a088cb3858 Modified Files -- doc/src/sgml/config.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) -- Sent via pgsql-committers mailing list (pgsql-comm

[COMMITTERS] pgsql: doc: Update wording about direct system catalog manipulation

2016-06-07 Thread Peter Eisentraut
doc: Update wording about direct system catalog manipulation It was previously suggested that "esoteric" operations such as creating a new access method would require direct manipulation of the system catalogs, but that example has gone away, and I can't think of a new one to replace it, so just p

[COMMITTERS] pgsql: Message style and wording fixes

2016-06-07 Thread Peter Eisentraut
Message style and wording fixes Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/5c6d2a5e7c83bf6e157fe4ca0ab9b123012289e9 Modified Files -- src/backend/access/gin/ginbulk.c | 2 +- src/backend/access/transam/xlogfuncs.c | 6 +++--- sr

[COMMITTERS] pgsql: Correct phrasing in dsm.c comments

2016-06-07 Thread Simon Riggs
Correct phrasing in dsm.c comments Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/1f74a901d5e7e3fc20508bc6fa47beeb6290 Modified Files -- src/backend/storage/ipc/dsm.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) -- Sent via pgsql-commi

[COMMITTERS] pgsql: Improve documentation for contrib/bloom.

2016-06-07 Thread Tom Lane
Improve documentation for contrib/bloom. Michael Paquier, David Johnston, Tom Lane Discussion: Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/cfd4804b1ebed8108ef6caedc76fb6eb37bc9724 Modified Files -- doc/src/sgml/bloom.sgml | 243

[COMMITTERS] pgsql: Update intagg extension for parallel query.

2016-06-07 Thread Robert Haas
Update intagg extension for parallel query. All functions provided by this extension are PARALLEL SAFE. Andreas Karlsson Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/1ab194a3a9c6a36a4259be846651eb597a98c862 Modified Files -- contrib/intagg/Makefile

[COMMITTERS] pgsql: Update citext extension for parallel query.

2016-06-07 Thread Robert Haas
Update citext extension for parallel query. All citext functions are PARALLEL SAFE, and a couple of them can benefit from having aggregate combine functions. Andreas Karlsson Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/a89b4b1be0d3550a7860250ff74dc69730555a1f M

[COMMITTERS] pgsql: Update earthdistance extension for parallel query.

2016-06-07 Thread Robert Haas
Update earthdistance extension for parallel query. All functions provided by this extension are PARALLEL SAFE. Andreas Karlsson Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/50e5226bb3272daac1edb13fce9b8e92be302d64 Modified Files -- contrib/earthdista

[COMMITTERS] pgsql: Update isn extension for parallel query.

2016-06-07 Thread Robert Haas
Update isn extension for parallel query. All functions provided by this extension are PARALLEL SAFE. Andreas Karlsson Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/b79b8d8f55522e7bc299efc4a41f02accdeaccbe Modified Files -- contrib/isn/Makefile

[COMMITTERS] pgsql: Update fuzzystrmatch extension for parallel query.

2016-06-07 Thread Robert Haas
Update fuzzystrmatch extension for parallel query. All functions provided by this extension are PARALLEL SAFE. Andreas Karlsson Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/ffab82fbda884bc73485d877dd7d528c4cb15e82 Modified Files -- contrib/fuzzystrma

[COMMITTERS] pgsql: Update lo extension for parallel query.

2016-06-07 Thread Robert Haas
Update lo extension for parallel query. The lo_oid function provided by this extension is PARALLEL SAFE. Andreas Karlsson Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/e7880e5d39d098d40717d23c9162b8e52294792a Modified Files -- contrib/lo/Makefile

Re: [HACKERS] Re: [COMMITTERS] pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold

2016-06-07 Thread Robert Haas
On Sat, Jun 4, 2016 at 4:21 PM, Kevin Grittner wrote: > On Fri, Jun 3, 2016 at 4:24 PM, Kevin Grittner wrote: >> Consequently, causing the index to be ignored in planning when >> using the old index > > That last line should have read "using an old snapshot" > >> is not a nice optimization, but n

[COMMITTERS] pgsql: Minor typos / copy-editing for snapmgr.c

2016-06-07 Thread Stephen Frost
Minor typos / copy-editing for snapmgr.c Noticed while reviewing snapshot management. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/40fc4575205dc563b88da1db9a8a75cc4d3b848a Modified Files -- src/backend/utils/time/snapmgr.c | 10 +- 1 file chang

[COMMITTERS] pgsql: psql: Add missing file to nls.mk

2016-06-07 Thread Peter Eisentraut
psql: Add missing file to nls.mk crosstabview.c was not added to nls.mk when it was added. Also remove redundant gettext markers, since psql_error() is already registered as a gettext keyword. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/d8c2dccfdb947d96082fdf4b4

[COMMITTERS] pgsql: pgbench: Fix order in --help output

2016-06-07 Thread Peter Eisentraut
pgbench: Fix order in --help output The new option --progress-timestamp was just added at the end. Put it in alphabetical order. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/298706de2692e3add3cfef2ac02e27f8f237785f Modified Files -- src/bin/pgbench/p

[COMMITTERS] pgsql: doc: Refer to table by id

2016-06-07 Thread Peter Eisentraut
doc: Refer to table by id Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/552346c5502ed93bb97e171f7206ea96f4de3a15 Modified Files -- doc/src/sgml/ref/pgbench.sgml | 14 +++--- 1 file changed, 7 insertions(+), 7 deletions(-) -- Sent via pgsql-com

[COMMITTERS] pgsql: Fix simple typo in monitoring docs

2016-06-07 Thread Simon Riggs
Fix simple typo in monitoring docs Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/29424a9c666b6722aac7527e388c2b01830a0990 Modified Files -- doc/src/sgml/monitoring.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) -- Sent via pgsql-committers

[COMMITTERS] pgsql: pg_dump only selected components of ACCESS METHODs

2016-06-07 Thread Stephen Frost
pg_dump only selected components of ACCESS METHODs dumpAccessMethod() didn't get the memo that we now have a bitfield for the components which should be dumped instead of a simple boolean. Correct that by checking if the relevant bit is set for each component being dumped out (and not dumping it

[COMMITTERS] pgsql: PL/Python: Move ereport wrapper test cases to separate file

2016-06-07 Thread Peter Eisentraut
PL/Python: Move ereport wrapper test cases to separate file In commit 5c3c3cd0a3046339597a03bc708cb5530dc07059, the new tests were apparently just dumped into the first convenient file. Move them to a separate file dedicated to testing that functionality and leave the plpython_test test to test b