[COMMITTERS] pgsql: Fix bogus handling of JOIN_UNIQUE_OUTER/INNER cases for parallel

2016-11-29 Thread Tom Lane
Fix bogus handling of JOIN_UNIQUE_OUTER/INNER cases for parallel joins. consider_parallel_nestloop passed the wrong jointype down to its subroutines for JOIN_UNIQUE_INNER cases (it should pass JOIN_INNER), and it thought that it could pass paths other than innerrel->cheapest_total_path to create_u

[COMMITTERS] pgsql: Fix bogus handling of JOIN_UNIQUE_OUTER/INNER cases for parallel

2016-11-29 Thread Tom Lane
Fix bogus handling of JOIN_UNIQUE_OUTER/INNER cases for parallel joins. consider_parallel_nestloop passed the wrong jointype down to its subroutines for JOIN_UNIQUE_INNER cases (it should pass JOIN_INNER), and it thought that it could pass paths other than innerrel->cheapest_total_path to create_u

[COMMITTERS] pgsql: Improve eqjoinsel_semi's behavior for small inner relations with

2016-11-29 Thread Tom Lane
Improve eqjoinsel_semi's behavior for small inner relations with no stats. If we don't have any MCV statistics for the inner relation, and we don't trust its numdistinct estimate either, eqjoinsel_semi falls back to a very conservative estimate (that 50% of the outer rows have matches). This is p

[COMMITTERS] pgsql: Straighten out some whitespace

2016-11-29 Thread Peter Eisentraut
Straighten out some whitespace Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/96fb4c90e3b227f3f1770fd2f7ea1e0478a4d37c Modified Files -- src/backend/Makefile | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) -- Sent via pgsql-committers mailing lis

[COMMITTERS] pgsql: Test all contrib-created operator classes with amvalidate.

2016-11-29 Thread Tom Lane
Test all contrib-created operator classes with amvalidate. I'd supposed that people would do this manually when creating new operator classes, but the folly of that was exposed today. The tests seem fast enough that we can just apply them during the normal regression tests. contrib/isn fails the

[COMMITTERS] pgsql: Add uuid to the set of types supported by contrib/btree_gist.

2016-11-29 Thread Tom Lane
Add uuid to the set of types supported by contrib/btree_gist. Paul Jungwirth, reviewed and hacked on by Teodor Sigaev, Ildus Kurbangaliev, Adam Brusselback, Chris Bandy, and myself. Discussion: https://postgr.es/m/CA+renyUEE29=X01JXdz8_TQvo6n9=2xoebbrnq8rklyr+kj...@mail.gmail.com Discussion: htt

[COMMITTERS] pgsql: libpq: Add target_session_attrs parameter.

2016-11-29 Thread Robert Haas
libpq: Add target_session_attrs parameter. Commit 274bb2b3857cc987cfa21d14775cae9b0dababa5 made it possible to specify multiple IPs in a connection string, but that's not good enough for the case where you have a read-write master and a bunch of read-only standbys and want to connect to whichever

[COMMITTERS] pgsql: Add --no-blobs option to pg_dump

2016-11-29 Thread Stephen Frost
Add --no-blobs option to pg_dump Add an option to exclude blobs when running pg_dump. By default, blobs are included but this option can be used to exclude them while keeping the rest of the dump. Commment updates and regression tests from me. Author: Guillaume Lelarge Reviewed-by: Amul Sul Dis

[COMMITTERS] pgsql: Fix incorrect variable type in set_rel_consider_parallel().

2016-11-29 Thread Tom Lane
Fix incorrect variable type in set_rel_consider_parallel(). func_parallel() returns char not Oid. Harmless, but still wrong. Amit Langote Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/d6c8b34e956864d52780f0db9f8cfe3b2f4411b0 Modified Files -- src/bac

[COMMITTERS] pgsql: Fix incorrect variable type in set_rel_consider_parallel().

2016-11-29 Thread Tom Lane
Fix incorrect variable type in set_rel_consider_parallel(). func_parallel() returns char not Oid. Harmless, but still wrong. Amit Langote Branch -- REL9_6_STABLE Details --- http://git.postgresql.org/pg/commitdiff/0c65061de26470f2b17e3856fd2afd6c266195b7 Modified Files --

[COMMITTERS] pgsql: Clarify pg_dump -b documentation

2016-11-29 Thread Stephen Frost
Clarify pg_dump -b documentation The documentation around the -b/--blobs option to pg_dump seemed to imply that it might be possible to add blobs to a "schema-only" dump or similar. Clarify that blobs are data and therefore will only be included in dumps where data is being included, even when -b

[COMMITTERS] pgsql: Clarify pg_dump -b documentation

2016-11-29 Thread Stephen Frost
Clarify pg_dump -b documentation The documentation around the -b/--blobs option to pg_dump seemed to imply that it might be possible to add blobs to a "schema-only" dump or similar. Clarify that blobs are data and therefore will only be included in dumps where data is being included, even when -b

[COMMITTERS] pgsql: Clarify pg_dump -b documentation

2016-11-29 Thread Stephen Frost
Clarify pg_dump -b documentation The documentation around the -b/--blobs option to pg_dump seemed to imply that it might be possible to add blobs to a "schema-only" dump or similar. Clarify that blobs are data and therefore will only be included in dumps where data is being included, even when -b

[COMMITTERS] pgsql: Clarify pg_dump -b documentation

2016-11-29 Thread Stephen Frost
Clarify pg_dump -b documentation The documentation around the -b/--blobs option to pg_dump seemed to imply that it might be possible to add blobs to a "schema-only" dump or similar. Clarify that blobs are data and therefore will only be included in dumps where data is being included, even when -b

[COMMITTERS] pgsql: Clarify pg_dump -b documentation

2016-11-29 Thread Stephen Frost
Clarify pg_dump -b documentation The documentation around the -b/--blobs option to pg_dump seemed to imply that it might be possible to add blobs to a "schema-only" dump or similar. Clarify that blobs are data and therefore will only be included in dumps where data is being included, even when -b

[COMMITTERS] pgsql: Clarify pg_dump -b documentation

2016-11-29 Thread Stephen Frost
Clarify pg_dump -b documentation The documentation around the -b/--blobs option to pg_dump seemed to imply that it might be possible to add blobs to a "schema-only" dump or similar. Clarify that blobs are data and therefore will only be included in dumps where data is being included, even when -b

[COMMITTERS] pgsql: Correct psql documentation example

2016-11-29 Thread Stephen Frost
Correct psql documentation example An example in the psql documentation had an incorrect field name from what the command actually produced. Pointed out by Fabien COELHO Back-patch to 9.6 where the example was added. Discussion: https://postgr.es/m/alpine.DEB.2.20.1611291349400.19314@lancre Br

[COMMITTERS] pgsql: Correct psql documentation example

2016-11-29 Thread Stephen Frost
Correct psql documentation example An example in the psql documentation had an incorrect field name from what the command actually produced. Pointed out by Fabien COELHO Back-patch to 9.6 where the example was added. Discussion: https://postgr.es/m/alpine.DEB.2.20.1611291349400.19314@lancre Br