Correctifs appliqués

Noah Misch pushed:

Robert Haas pushed:

Andrew Dunstan pushed:

Tom Lane pushed:

Dean Rasheed pushed:

  • Use MINVALUE/MAXVALUE instead of UNBOUNDED for range partition bounds. Previously, UNBOUNDED meant no lower bound when used in the FROM list, and no upper bound when used in the TO list, which was OK for single-column range partitioning, but problematic with multiple columns. For example, an upper bound of (10.0, UNBOUNDED) would not be collocated with a lower bound of (10.0, UNBOUNDED), thus making it difficult or impossible to define contiguous multi-column range partitions in some cases. Fix this by using MINVALUE and MAXVALUE instead of UNBOUNDED to represent a partition column that is unbounded below or above respectively. This syntax removes any ambiguity, and ensures that if one partition's lower bound equals another partition's upper bound, then the partitions are contiguous. Also drop the constraint prohibiting finite values after an unbounded column, and just document the fact that any values after MINVALUE or MAXVALUE are ignored. Previously it was necessary to repeat UNBOUNDED multiple times, which was needlessly verbose. Note: Forces a post-PG 10 beta2 initdb. Report by Amul Sul, original patch by Amit Langote with some additional hacking by me. Discussion: https://postgr.es/m/CAAJ_b947mowpLdxL3jo3YLKngRjrq9+Ej4ymduQTfYR+8=YAYQ@mail.gmail.com https://git.postgresql.org/pg/commitdiff/d363d42bb9a4399a0207bd3b371c966e22e06bd3
  • Make the new partition regression tests locale-independent. The order of partitions listed by \d+ is in general locale-dependent. Rename the partitions in the test added by d363d42bb9 to force them to be listed in a consistent order. https://git.postgresql.org/pg/commitdiff/68f785fd522bca9372cce965ac10cbd8c239c076

Teodor Sigaev pushed:

  • Fix double shared memory allocation. SLRU buffer lwlocks are allocated twice by oversight in commit fe702a7b3f9f2bc5bf6d173166d7d55226af82c8 where that locks were moved to separate tranche. The bug doesn't have user-visible effects except small overspending of shared memory. Backpatch to 9.6 where it was introduced. Alexander Korotkov with small editorization by me. https://git.postgresql.org/pg/commitdiff/7e1fb4c59e4ac86de2640d0f3453fde270ec1ff8

�lvaro Herrera pushed:

Correctifs en attente

Amit Kapila sent in another revision of a patch to parallelize queries containing initplans.

Shubham Barai sent in another revision of a patch to add predicate locking for GIN indexes.

Thomas Munro sent in two more revisions of a patch to add more flexible LDAP filters.

Alik Khilazhev sent in another revision of a patch to add Zipfian distributions to pgbench.

Andres Freund sent in two revisions of a patch to move ExecProcNode from dispatch to callback based model.

Alexey Chernyshov sent in a patch to add citext_pattern_ops to the citext contrib module.

Yura Sokolov sent in another revision of a patch to fix performance degradation of contended LWLock on NUMA.

Yugo Nagata sent in a patch to ensure that all statistics are sent after a few DML are performed.

Marina Polyakova sent in another revision of a patch to precalculate stable functions.

Yura Sokolov sent in two revisions of a patch to increase the size of the vacuum ring buffer.

Mark Rofail sent in another revision of a patch to add foreign key arrays.

Victor Drobny sent in a patch to add queryto_tsquery(), which takes a 'google like' query string and translates it to tsquery.

Robins Tharakan sent in two revisions of a patch to add --no-comments to pg_dump.

Mark Dilger sent in two revisions of a patch to remove abstime and friends from the main line code base.

Fabien COELHO sent in a patch to fix the documentation of random_exponential.

Etsuro Fujita sent in two more revisions of a patch to fix the rewrite tlist.

Jeevan Ladhe sent in another revision of a patch to add support for default partitions in declarative partitions.

Yugo Nagata sent in a patch to fix incorrect comments of XLByteToSeg() and XLByteToPrevSeg().

Thomas Munro sent in three revisions of a patch to fix join selectivity for <> comparisons.

Craig Ringer sent in two revisions of a patch to introduce heap_infomask_flags to decode infomask and infomask2.

Micha�l Paquier sent in a patch to check for objaddr nullness.

Etsuro Fujita sent in two revisions of a patch to fix mishandling of WITH CHECK OPTION constraints in direct foreign table modification.

Yugo Nagata and Fabr�zio de Royes Mello traded patches to add hooks for session_start and session_end.

Yura Sokolov sent in another revision of a patch to make an improvement to compactify_tuples by simplifyin PageRepairFragmentation.

Alexey Chernyshov sent in a patch to add functions on GIN and GiST indexes to pageinspect.

Hadi Moshayedi move the declarations of ExplainBeginGroup()/ExplainEndGroup() from explain.c to explain.h.

Marina Polyakova sent in another revision of a patch to pgbench to retry transactions with serialization or deadlock errors.

Mengxing Liu sent in another revision of a patch to eliminate O(N^2) scaling from rw-conflict tracking in serializable transactions using a skip list.

Dima Pavlov sent in a patch to improve perfomance for index search ANY(ARRAY[]) condition with single item.