Featured content is also available via:

PostgreSQL

PostgeSQL is a leading open-source SQL database server.

www.postgresql.org

Other Activity This Week

Prevent drop of tablespaces used by partitioned relations
Alvaro Herrera: When a tablespace is used in a partitioned relation (per commits ca4103025dfe in pg12 for tables and 33e6c34c3267 in pg11 for indexes), it is possible to drop the tablespace, potentially causing various problems.

Ensure that a standby is able to follow a primary on a newer timeline
Fujii Masao: Commit 709d003fbd refactored WAL-reading code, but accidentally caused WalSndSegmentOpen() to fail to follow a timeline switch while reading from a historic timeline.

Move our p{read,write}v replacements into their own files
Thomas Munro: macOS's ranlib issued a warning about an empty pread.o file with the previous arrangement, on systems new enough to require no replacement functions.

Enhance nbtree index tuple deletion
Peter Geoghegan: Teach nbtree and heapam to cooperate in order to eagerly remove duplicate tuples representing dead MVCC versions.

Pass down "logically unchanged index" hint
Peter Geoghegan: Add an executor aminsert() hint mechanism that informs index AMs that the incoming index tuple (the tuple that accompanies the hint) is not being inserted by execution of an SQL statement that logically modifies any of the index's key columns. The hint is received by indexes when an UPDATE takes place that does not apply an optimization like heapam's HOT (though only for indexes where all key columns are logically unchanged).

Optimize DropRelFileNodeBuffers() for recovery
Amit Kapila: The recovery path of DropRelFileNodeBuffers() is optimized so that scanning of the whole buffer pool can be avoided when the number of blocks to be truncated in a relation is below a certain threshold.

Recent Activity

Prevent drop of tablespaces used by partitioned relations
Alvaro Herrera: When a tablespace is used in a partitioned relation (per commits ca4103025dfe in pg12 for tables and 33e6c34c3267 in pg11 for indexes), it is possible to drop the tablespace, potentially causing various problems.

Ensure that a standby is able to follow a primary on a newer timeline
Fujii Masao: Commit 709d003fbd refactored WAL-reading code, but accidentally caused WalSndSegmentOpen() to fail to follow a timeline switch while reading from a historic timeline.

Move our p{read,write}v replacements into their own files
Thomas Munro: macOS's ranlib issued a warning about an empty pread.o file with the previous arrangement, on systems new enough to require no replacement functions.

Enhance nbtree index tuple deletion
Peter Geoghegan: Teach nbtree and heapam to cooperate in order to eagerly remove duplicate tuples representing dead MVCC versions.

Pass down "logically unchanged index" hint
Peter Geoghegan: Add an executor aminsert() hint mechanism that informs index AMs that the incoming index tuple (the tuple that accompanies the hint) is not being inserted by execution of an SQL statement that logically modifies any of the index's key columns. The hint is received by indexes when an UPDATE takes place that does not apply an optimization like heapam's HOT (though only for indexes where all key columns are logically unchanged).

Optimize DropRelFileNodeBuffers() for recovery
Amit Kapila: The recovery path of DropRelFileNodeBuffers() is optimized so that scanning of the whole buffer pool can be avoided when the number of blocks to be truncated in a relation is below a certain threshold.

Add GUC to log long wait times on recovery conflicts
Fujii Masao: This commit adds GUC log_recovery_conflict_waits that controls whether a log message is produced when the startup process is waiting longer than deadlock_timeout for recovery conflicts.

Improve timeout.c's handling of repeated timeout set/cancel
Tom Lane: A very common usage pattern is that we set a timeout that we don't expect to reach, cancel it after a little bit, and later repeat.

Replace CLOBBER_CACHE_ALWAYS with run-time GUC
Peter Eisentraut: Forced cache invalidation (CLOBBER_CACHE_ALWAYS) has been impractical to use for testing in PostgreSQL because it's so slow and because it's toggled on/off only at build time.

Detect the deadlocks between backends and the startup process
Fujii Masao: The deadlocks that the recovery conflict on lock is involved in can happen between hot-standby backends and the startup process.

PostgreSQL Release Tags

nbtree: BTREE_[MIN|NOVAC]_VERSION comment tweaks
Peter Geoghegan: Author: Peter Geoghegan

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

Add key management system
Bruce Momjian: This adds a key management system that stores (currently) two data encryption keys of length 128, 192, or 256 bits.

Allow decoding at prepare time in ReorderBuffer
Amit Kapila: This patch allows PREPARE-time decoding of two-phase transactions (if the output plugin supports this capability), in which case the transactions are replayed at PREPARE and then committed later when COMMIT PREPARED arrives. Now that we decode the changes before the commit, the concurrent aborts may cause failures when the output plugin consults catalogs (both system and user-defined). We detect such failures with a special sqlerrcode ERRCODE_TRANSACTION_ROLLBACK introduced by commit 7259736a6e and stop decoding the remaining changes.

Add scripts for retrieving the cluster file encryption key
Bruce Momjian: Scripts are passphrase, direct, AWS, and two Yubikey ones.

Avoid time-of-day-dependent failure in log rotation test
Tom Lane: Buildfarm members pogona and petalura have shown a failure when pg_ctl/t/004_logrotate.pl starts just before local midnight.

Add pg_alterckey utility to change the cluster key
Bruce Momjian: This can change the key that encrypts the data encryption keys used for cluster file encryption.

Use setenv() in preference to putenv().
Tom Lane: Since at least 2001 we've used putenv() and avoided setenv(), on the grounds that the latter was unportable and not in POSIX.

Add support of multirange matching to the existing range GiST indexes
Alexander Korotkov: 6df7a9698b has introduced a set of operators between ranges and multiranges.

Enhance nbtree index tuple deletion
Peter Geoghegan: Teach nbtree and heapam to cooperate in order to eagerly remove duplicate tuples representing dead MVCC versions.

Add GUC to log long wait times on recovery conflicts
Fujii Masao: This commit adds GUC log_recovery_conflict_waits that controls whether a log message is produced when the startup process is waiting longer than deadlock_timeout for recovery conflicts.

Extend the output plugin API to allow decoding of prepared xacts
Amit Kapila: This adds six methods to the output plugin API, adding support for streaming changes of two-phase transactions at prepare time. - begin_prepare - filter_prepare - prepare - commit_prepared - rollback_prepared - stream_prepare Most of this is a simple extension of the existing methods, with the semantic difference that the transaction is not yet committed and maybe aborted later. Until now two-phase transactions were translated into regular transactions on the subscriber, and the GID was not forwarded to it.

Legal Disclaimer & Disclosure | Contact Us
Copyright © 2010 - 2021 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).