Featured content is also available via:

PostgreSQL

PostgeSQL is a leading open-source SQL database server.

www.postgresql.org

Other Activity This Week

Minor mop-up for List improvements
Tom Lane: Fix a few places that were using written-out versions of the pg_list.h macros that commit cc99baa43 just improved, making them also use those macros so as to gain whatever performance improvement is to be had.

Move resolution of AlternativeSubPlan choices to the planner
Tom Lane: When commit bd3daddaf introduced AlternativeSubPlans, I had some ambitions towards allowing the choice of subplan to change during execution.

Recent Activity

Minor mop-up for List improvements
Tom Lane: Fix a few places that were using written-out versions of the pg_list.h macros that commit cc99baa43 just improved, making them also use those macros so as to gain whatever performance improvement is to be had.

Move resolution of AlternativeSubPlan choices to the planner
Tom Lane: When commit bd3daddaf introduced AlternativeSubPlans, I had some ambitions towards allowing the choice of subplan to change during execution.

Add new 'old_snapshot' contrib module
Robert Haas: You can use this to view the contents of the time to XID mapping which the server maintains when old_snapshot_threshold != -1.

Improve error cursor positions for problems with partition bounds
Tom Lane: We failed to pass down the query string to check_new_partition_bound, so that its attempts to provide error cursor positions were for naught; one must have the query string to get parser_errposition to do anything.

Allow most keywords to be used as column labels without requiring AS.
Tom Lane: Up to now, if you tried to omit "AS" before a column label in a SELECT list, it would only work if the column label was an IDENT, that is not any known keyword.

Remove support for postfix (right-unary) operators
Tom Lane: This feature has been a thorn in our sides for a long time, causing many grammatical ambiguity problems.

Improve common/logging.c's support for multiple verbosity levels
Tom Lane: Instead of hard-wiring specific verbosity levels into the option processing of client applications, invent pg_logging_increase_verbosity() and encourage clients to implement --verbose by calling that.

Add support for building GiST index by sorting
Heikki Linnakangas: This adds a new optional support function to the GiST access method: sortsupport.

Centralize setup of SIGQUIT handling for postmaster child processes
Tom Lane: We decided that the policy established in commit 7634bd4f6 for the bgwriter, checkpointer, walwriter, and walreceiver processes, namely that they should accept SIGQUIT at all times, really ought to apply uniformly to all postmaster children.

Avoid unnecessary recursion to child tables in ALTER TABLE SET NOT NULL.
Tom Lane: If a partitioned table's column is already marked NOT NULL, there is no need to examine its partitions, because we can rely on previous DDL to have enforced that the child columns are NOT NULL as well.

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 support for building GiST index by sorting
Heikki Linnakangas: This adds a new optional support function to the GiST access method: sortsupport.

Add support for partitioned tables and indexes in REINDEX
Michael Paquier: Until now, REINDEX was not able to work with partitioned tables and indexes, forcing users to reindex partitions one by one.

Add d_type to our Windows dirent emulation
Thomas Munro: This allows us to skip some stat calls, by extending commit 861c6e7c to cover Windows systems.

Add support for streaming to built-in logical replication
Amit Kapila: To add support for streaming of in-progress transactions into the built-in logical replication, we need to do three things: - Extend the logical replication protocol, so identify in-progress transactions, and allow adding additional bits of information (e.g.

doc: Tweak sentence for pg_checksums when enabling checksums
Michael Paquier: The previous version of the docs mentioned that files are rewritten, implying that a second copy of each file gets created, but each file is updated in-place.

Check default partitions constraints while descending
Alvaro Herrera: Partitioning tuple route code assumes that the partition chosen while descending the partition hierarchy is always the correct one.

Apply auto-vectorization to the inner loop of numeric multiplication
Tom Lane: Compile numeric.c with -ftree-vectorize where available, and adjust the innermost loop of mul_var() so that it is amenable to being auto-vectorized.

Yet more elimination of dead stores and useless initializations
Tom Lane: I'm not sure what tool Ranier was using, but the ones I contributed were found by using a newer version of scan-build than I tried before.

Remove support for postfix (right-unary) operators
Tom Lane: This feature has been a thorn in our sides for a long time, causing many grammatical ambiguity problems.

Optimize compactify_tuples function
David Rowley: This function could often be seen in profiles of vacuum and could often be a significant bottleneck during recovery.

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