PostgreSQL
PostgeSQL is a leading open-source SQL database server.
www.postgresql.org
Recent Activity
- Disconnect if socket cannot be put into non-blocking mode
Heikki Linnakangas: Commit 387da18874 moved the code to put socket into non-blocking mode from socket_set_nonblocking() into the one-time initialization function, pq_init(). - Improve consistency of replication slot statistics
Michael Paquier: The replication slot stats stored in shared memory rely on an internal index number. - Add some checkpoint and redo LSNs to a couple of recovery errors
Michael Paquier: Two FATALs and one PANIC gain details about the LSNs they fail at:- When restoring from a backup_label, the FATAL log generated when not finding the checkpoint record now reports its LSN.- When restoring from a backup_label, the FATAL log generated when not finding the redo record referenced by a checkpoint record now shows both the redo and checkpoint record LSNs.- When not restoring from a backup_label, the PANIC error generated when not finding the checkpoint record now reports its LSN. - Introduce a new GUC 'standby_slot_names'.
Amit Kapila: This patch provides a way to ensure that physical standbys that are potential failover candidates have received and flushed changes before the primary server making them visible to subscribers. - Add support for DEFAULT in ALTER TABLE .. SET ACCESS METHOD
Michael Paquier: This option can be used to switch a relation to use the access method set by default_table_access_method when running the command. - Add template for adaptive radix tree
John Naylor: This implements a radix tree data structure based on the design in "The Adaptive Radix Tree: ARTful Indexing for Main-Memory Databases" by Viktor Leis, Alfons Kemper, and ThomasNeumann, 2013. - Add Unicode property tables
Jeff Davis: Provide functions to test for Unicode properties, such as Alphabetic or Cased. - Fix signedness error in 9f225e992 for gcc
John Naylor: The first argument of vshrq_n_s8 needs to be a signed vector type, but it was passed unsigned. - Add --copy-file-range option to pg_upgrade
Thomas Munro: The copy_file_range() system call is available on at least Linux and FreeBSD, and asks the kernel to use efficient ways to copy ranges of a file. - Rename pg_constraint.conwithoutoverlaps to conperiod
Peter Eisentraut: pg_constraint.conwithoutoverlaps was recently added to support primary keys and unique constraints with the WITHOUT OVERLAPS clause.
Most Popular In The Past Month
- Remove the adminpack contrib extension
Daniel Gustafsson: The adminpack extension was only used to support pgAdmin III, which in turn was declared EOL many years ago. - Support MERGE into updatable views
Dean Rasheed: This allows the target relation of MERGE to be an auto-updatable or trigger-updatable view, and includes support for WITH CHECK OPTION, security barrier views, and security invoker views.
A trigger-updatable view must have INSTEAD OF triggers for every type of action (INSERT, UPDATE, and DELETE) mentioned in the MERGE command. - Rename pg_constraint.conwithoutoverlaps to conperiod
Peter Eisentraut: pg_constraint.conwithoutoverlaps was recently added to support primary keys and unique constraints with the WITHOUT OVERLAPS clause. - Introduce a new smgr bulk loading facility
Heikki Linnakangas: The new facility makes it easier to optimize bulk loading, as the logic for buffering, WAL-logging, and syncing the relation only needs to be implemented once. - Disconnect if socket cannot be put into non-blocking mode
Heikki Linnakangas: Commit 387da18874 moved the code to put socket into non-blocking mode from socket_set_nonblocking() into the one-time initialization function, pq_init(). - Add a new slot sync worker to synchronize logical slots
Amit Kapila: By enabling slot synchronization, all the failover logical replication slots on the primary (assuming configurations are appropriate) are automatically created on the physical standbys and are synced periodically. - Improve performance of subsystems on top of SLRU
Alvaro Herrera: More precisely, what we do here is make the SLRU cache sizes configurable with new GUCs, so that sites with high concurrency and big ranges of transactions in flight (resp. - Add lookup table for replication slot conflict reasons
Michael Paquier: This commit switches the handling of the conflict cause strings for replication slots to use a table rather than being explicitly listed, using a C99-designated initializer syntax for the array elements. - Minor corrections for partition pruning
David Rowley: When the partition pruning code finds an OpExpr with an operator that does not belong to the partition key's opfamily, the code checks to see if the negator of the operator is the opfamily's BTEqualStrategyNumber operator so that partition pruning can support that operator and invert the matching partitions. - Add Unicode property tables
Jeff Davis: Provide functions to test for Unicode properties, such as Alphabetic or Cased.