[COMMITTERS] pgsql: Use quicksort, not replacement selection, for external sorting.

Use quicksort, not replacement selection, for external sorting. We still use replacement selection for the first run of the sort only and only when the number of tuples is relatively small. Otherwise, the first run, and subsequent runs in all cases, are produced using quicksort. This tends to be

[COMMITTERS] pgsql: Extend relations multiple blocks at a time to improve scalabilit

Extend relations multiple blocks at a time to improve scalability. Contention on the relation extension lock can become quite fierce when multiple processes are inserting data into the same relation at the same time at a high rate. Experimentation shows the extending the relation multiple blocks

[COMMITTERS] pgsql: Fix a couple of places in doc that implied there was only one sy

Fix a couple of places in doc that implied there was only one sync standby. Thomas Munro Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/8643b91ecf8f47a1307df4a00d66b2fceada0d6f Modified Files -- doc/src/sgml/high-availability.sgml | 13 +++-- 1 f

Re: [COMMITTERS] pgsql: Phrase full text search.

I wrote: > ... I'm looking at the patch delta in ts_type.h. BTW, while I'm looking at that: comparePos() was a perfectly OK name for a static function within tsvector.c, but it seems like a pretty horrid name for a globally exposed linker symbol. Please rename it to something less generic.

Re: [COMMITTERS] pgsql: Phrase full text search.

Teodor Sigaev writes: > Phrase full text search. Hasn't this patch broken on-disk compatibility of type tsquery by renumbering the values of QueryOperator.operator? I'm looking at the patch delta in ts_type.h. regards, tom lane -- Sent via pgsql-committers mailing lis

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

Use Foreign Key relationships to infer multi-column join selectivity In cases where joins use multiple columns we currently assess each join separately causing gross mis-estimates for join cardinality. This patch adds use of FK information for the first time into the planner. When FKs are present

Re: [COMMITTERS] pgsql: Load FK defs into relcache for use by planner

On Thu, Apr 7, 2016 at 4:09 AM, Simon Riggs wrote: > Load FK defs into relcache for use by planner I gather this is infrastructure for the "use foreign keys to improve join estimates" patch. A more worked out commit message would be nice, though. -- Peter Geoghegan -- Sent via pgsql-committ

[COMMITTERS] pgsql: GRANT rights to CURRENT_USER instead of adding roles

GRANT rights to CURRENT_USER instead of adding roles We shouldn't be adding roles during the regression tests as that can cause back-to-back installcheck runs to fail and users running the regression tests likley don't want those extra roles. Pointed out by Tom Branch -- master Details

[COMMITTERS] pgsql: Zeroing unused parts ducring tsquery construction.

Zeroing unused parts ducring tsquery construction. Per investigation failure skink buildfarm member and RANDOMIZE_ALLOCATED_MEMORY help Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/3308467905aa157139d24375850cfe49ee90a0cf Modified Files -- src/backend

[COMMITTERS] pgsql: Refactor join_is_removable() to separate out distinctness-provin

Refactor join_is_removable() to separate out distinctness-proving logic. Extracted from pending unique-join patch, since this is a rather large delta but it's simply moving code out into separately-accessible subroutines. I (tgl) did choose to add a bit more logic to rel_supports_distinctness, so

[COMMITTERS] pgsql: Make testing of phraseto_tsquery independ from value of

Make testing of phraseto_tsquery independ from value of default_text_search_config variable. Per skink buldfarm member Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/a7ace3b6d96c7a1539ed0700865d320258a12f73 Modified Files -- src/test/regress/expected/ts

[COMMITTERS] pgsql: Detect SSI conflicts before reporting constraint violations

Detect SSI conflicts before reporting constraint violations While prior to this patch the user-visible effect on the database of any set of successfully committed serializable transactions was always consistent with some one-at-a-time order of execution of those transactions, the presence of decla

[COMMITTERS] pgsql: Phrase full text search.

Phrase full text search. Patch introduces new text search operator (<-> or ) into tsquery. On-disk and binary in/out format of tsquery are backward compatible. It has two side effect: - change order for tsquery, so, users, who has a btree index over tsquery, should reindex it - less number of pa

Re: [COMMITTERS] pgsql: Generic Messages for Logical Decoding

On Thu, Apr 7, 2016 at 1:47 PM, Andres Freund wrote: > On 2016-04-07 12:26:28 +0900, Fujii Masao wrote: >> In my example, the WAL record of INSERT that I executed last should be in >> 00010005. But pg_xlogdump could not display that. >> The output of pg_xlogdump was: >> >> $ pg_xlo

[COMMITTERS] pgsql: Load FK defs into relcache for use by planner

Load FK defs into relcache for use by planner Fastpath ignores this if no triggers defined. Author: Tomas Vondra, with fastpath and comments added by me Reviewers: David Rowley, Simon Riggs Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/015e88942aa50f0d419ddac00e63