Featured content is also available via:

PostgreSQL

PostgeSQL is a leading open-source SQL database server.

www.postgresql.org

Other Activity This Week

For all ppc compilers, implement compare_exchange and fetch_add with asm
Noah Misch: This is more like how we handle s_lock.h and arch-x86.h.

Fix typo
Alvaro Herrera: Apparently while this code was being developed, ReindexRelationConcurrently operated on multiple relations.

Recent Activity

For all ppc compilers, implement compare_exchange and fetch_add with asm
Noah Misch: This is more like how we handle s_lock.h and arch-x86.h.

Fix typo
Alvaro Herrera: Apparently while this code was being developed, ReindexRelationConcurrently operated on multiple relations.

Fix CLUSTER on expression indexes
Andres Freund: Since the introduction of different slot types, in 1a0586de3657, we create a virtual slot in tuplesort_begin_cluster().

In the postmaster, rely on the signal infrastructure to block signals
Tom Lane: POSIX sigaction(2) can be told to block a set of signals while a signal handler executes.

Fix dependency handling of column drop with partitioned tables
Michael Paquier: When dropping a column on a partitioned table which has one or more partitioned indexes, the operation was failing as dependencies with partitioned indexes using the column dropped were not getting removed in a way consistent with the columns involved across all the relations part of an inheritance tree. This commit refactors the code executing column drop so as all the columns from an inheritance tree to remove are gathered first, and dropped all at the end.

AIX: Stop adding option -qsrcmsg
Noah Misch: With xlc v16.1.0, it causes internal compiler errors.

Fix table rewrites that include a column without a default
Andres Freund: In c2fe139c201c I made ATRewriteTable() use tuple slots.

Remove some code for old unsupported versions of MSVC
Peter Eisentraut: As of d9dd406fe281d22d5238d3c26a7182543c711e74, we require MSVC 2013, which means _MSC_VER >= 1800.

Avoid trying to release a List's initial allocation via repalloc().
Tom Lane: Commit 1cff1b95a included some code that supposed it could repalloc() a memory chunk to a smaller size without risk of the chunk moving.

Avoid unnecessary out-of-memory errors during encoding conversion
Tom Lane: Encoding conversion uses the very simplistic rule that the output can't be more than 4X longer than the input, and palloc's a buffer of that size.

PostgreSQL Release Tags

Automate the maintenance of SO_MINOR_VERSION for our shared libraries
Tom Lane: Up to now we've manually adjusted these numbers in several different Makefiles at the start of each development cycle.

Advance PG_CONTROL_VERSION.
Tom Lane: This should have been done in commit 73c986adde5d73a5 which added several new fields to pg_control, and again in commit 5028f22f6eb05798 which changed the CRC algorithm, but it wasn't.

Tab complete CREATE EXTENSION .. VERSION.
Robert Haas: Jeff Janes

Bump PG_CONTROL_VERSION for previous 9.4 changes
Tom Lane: This should have been done in 6bc8ef0b7f1f1df3998745a66e1790e27424aa0c and/or 50e547096c4858a68abf09894667a542cc418315, but better late than never.

Most Popular In The Past Month

Have pg_rewind run crash recovery before rewinding
Alvaro Herrera: If we don't do this, the rewind fails if the server wasn't cleanly shut down, which seems unhelpful serving no purpose.

Fix handling of GENERATED columns in CREATE TABLE LIKE INCLUDING DEFAULTS.
Tom Lane: LIKE INCLUDING DEFAULTS tried to copy the attrdef expression without copying the state of the attgenerated column.

doc: Add a link target
Peter Eisentraut: Forward-patched from PostgreSQL 12 release notes patch, for consistency.

Add hooks for session start and session end, take two
Michael Paquier: These hooks can be used in loadable modules.

Add tab completion for EXPLAIN (SETTINGS) in psql
Michael Paquier

pgbench: add --partitions and --partition-method options
Amit Kapila: These new options allow users to partition the pgbench_accounts table by specifying the number of partitions and partitioning method.

Rely on plan_cache_mode to force generic plans in partition_prune test
Tom Lane: This file had a very weird mix of tests that did "set plan_cache_mode = force_generic_plan" to get a generic plan, and tests that relied on using five dummy executions of a prepared statement.

Optimize partial TOAST decompression
Tomas Vondra: Commit 4d0e994eed added support for partial TOAST decompression, so the decompression is interrupted after producing the requested prefix.

Avoid unnecessary out-of-memory errors during encoding conversion
Tom Lane: Encoding conversion uses the very simplistic rule that the output can't be more than 4X longer than the input, and palloc's a buffer of that size.

Fix table rewrites that include a column without a default
Andres Freund: In c2fe139c201c I made ATRewriteTable() use tuple slots.

Legal Disclaimer & Disclosure | Contact Us
Copyright © 2010 - 2019 by Phoronix Media. All rights reserved.
All trademarks and copyrights used are properties of their respective owners.
Powered by the Phoronix Content Management System (PHXCMS-8).