Featured content is also available via:

PostgreSQL

PostgeSQL is a leading open-source SQL database server.

www.postgresql.org

Other Activity This Week

Add a copyright notice to perl files lacking one
Andrew Dunstan

Have ALTER CONSTRAINT recurse on partitioned tables
Alvaro Herrera: When ALTER TABLE ..

Remove mention of the version number from pg_trgm docs
Alexander Korotkov: We don't usually mention the version number in similar situations.

doc: Add index entry for "multirange type"
Peter Eisentraut: Before now, looking up "multirange" in the index only led to the multirange() function.

Recent Activity

Add a copyright notice to perl files lacking one
Andrew Dunstan

Have ALTER CONSTRAINT recurse on partitioned tables
Alvaro Herrera: When ALTER TABLE ..

Remove mention of the version number from pg_trgm docs
Alexander Korotkov: We don't usually mention the version number in similar situations.

doc: Add index entry for "multirange type"
Peter Eisentraut: Before now, looking up "multirange" in the index only led to the multirange() function.

Doc: add an example of a self-referential foreign key to ddl.sgml
Tom Lane: While we've always allowed such cases, the documentation didn't say you could do it.

Adjust EXPLAIN output for parallel Result Cache plans
David Rowley: Here we adjust the EXPLAIN ANALYZE output for Result Cache so that we don't show any Result Cache stats for parallel workers who don't contribute anything to Result Cache plan nodes. I originally had ideas that workers who don't help could still have their Result Cache stats displayed.

Allow a partdesc-omitting-partitions to be cached
Alvaro Herrera: Makes partition descriptor acquisition faster during the transient period in which a partition is in the process of being detached. This also adds the restriction that only one partition can be in pending-detach state for a partitioned table. While at it, return find_inheritance_children() API to what it was before 71f4c8c6f74b, and create a separate find_inheritance_children_extended() that returns detailed info about detached partitions. (This incidentally fixes a bug in 8aba9322511 whereby a memory context holding a transient partdesc is reparented to a NULL PortalContext, leading to permanent leak of that memory.

Improve logic in PostgresVersion.pm
Andrew Dunstan: Handle the situation where perl swaps the order of operands of the comparison operator.

Teach PostgresVersion all the ways to mark non-release code
Andrew Dunstan: As well as 'devel' version_stamp.pl provides for 'alphaN' 'betaN' and 'rcN', so teach PostgresVersion about those.

Add comment about extract_autovac_opts not holding lock
Alvaro Herrera: Per observation from Tom Lane.

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 information of total data processed to replication slot stats
Amit Kapila: This adds the statistics about total transactions count and total transaction data logically sent to the decoding output plugin from ReorderBuffer.

Standardize pg_authid oid_symbol values
Noah Misch: Commit c9c41c7a337d3e2deb0b2a193e9ecfb865d8f52b used two different naming patterns.

Support tab-complete for TRUNCATE on foreign tables
Fujii Masao: Commit 8ff1c94649 extended TRUNCATE command so that it can also truncate foreign tables.

Rethink extraction of collation dependencies
Tom Lane: As it stands, find_expr_references_walker() pays attention to leaf-node collation fields while ignoring the input collations of actual function and operator nodes.

Add CURRENT_ROLE to list of roles for tab completion of GRANT in psql
Michael Paquier: This compatibility has been added in 45b9805, but psql forgot the call.

Teach PostgresVersion all the ways to mark non-release code
Andrew Dunstan: As well as 'devel' version_stamp.pl provides for 'alphaN' 'betaN' and 'rcN', so teach PostgresVersion about those.

Add comment about extract_autovac_opts not holding lock
Alvaro Herrera: Per observation from Tom Lane.

Allow a partdesc-omitting-partitions to be cached
Alvaro Herrera: Makes partition descriptor acquisition faster during the transient period in which a partition is in the process of being detached. This also adds the restriction that only one partition can be in pending-detach state for a partitioned table. While at it, return find_inheritance_children() API to what it was before 71f4c8c6f74b, and create a separate find_inheritance_children_extended() that returns detailed info about detached partitions. (This incidentally fixes a bug in 8aba9322511 whereby a memory context holding a transient partdesc is reparented to a NULL PortalContext, leading to permanent leak of that memory.

Improve logic in PostgresVersion.pm
Andrew Dunstan: Handle the situation where perl swaps the order of operands of the comparison operator.

adjust query id feature to use pg_stat_activity.query_id
Bruce Momjian: Previously, it was pg_stat_activity.queryid to match the pg_stat_statements queryid column.

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).