Featured content is also available via:

PostgreSQL

PostgeSQL is a leading open-source SQL database server.

www.postgresql.org

Today's Activity

Add infrastructure to track WAL usage
Amit Kapila: This allows gathering the WAL generation statistics for each statement execution.

Be more careful about time_t vs. pg_time_t in basebackup.c
Robert Haas: lapwing is complaining that about a call to pg_gmtime, saying that it "expected 'const pg_time_t *' but argument is of type 'time_t *'".

Yesterday's Activity

Generate backup manifests for base backups, and validate them
Robert Haas: A manifest is a JSON document which includes (1) the file name, size, last modification time, and an optional checksum for each file backed up, (2) timelines and LSNs for whatever WAL will need to be replayed to make the backup consistent, and (3) a checksum for the manifest itself.

Add a glossary to the documentation
Alvaro Herrera: More work is still needed, but this is a good start.

Add wait events for recovery conflicts
Fujii Masao: This commit introduces new wait events RecoveryConflictSnapshot and RecoveryConflictTablespace.

Add support for \aset in pgbench
Michael Paquier: This option is similar to \gset, except that it is able to store all results from combined SQL queries into separate variables.

Other Activity This Week

Allow pg_stat_statements to track planning statistics
Fujii Masao: This commit makes pg_stat_statements support new GUC pg_stat_statements.track_planning.

Collect statistics about SLRU caches
Tomas Vondra: There's a number of SLRU caches used to access important data like clog, commit timestamps, multixact, asynchronous notifications, etc.

Add support for binary I/O of ltree, lquery, and ltxtquery types
Tom Lane: Not much to say here --- does what it says on the tin.

Check equality semantics for unique indexes on partitioned tables
Tom Lane: We require the partition key to be a subset of the set of columns being made unique, so that physically-separate indexes on the different partitions are sufficient to enforce the uniqueness constraint. The existing code checked that the listed columns appear, but did not inquire into the index semantics, which is a serious oversight given that different index opclasses might enforce completely different notions of uniqueness. Ideally, perhaps, we'd just match the partition key opfamily to the index opfamily.

Correct CREATE INDEX documentation for opclass parameters
Alexander Korotkov: Old versions of opclass parameters patch supported ability to specify DEFAULT as the opclass name in CREATE INDEX command.

Add -c/--restore-target-wal to pg_rewind
Michael Paquier: pg_rewind needs to copy from the source cluster to the target cluster a set of relation blocks changed from the previous checkpoint where WAL forked up to the end of WAL on the target.

Add CREATE INDEX deduplication assertions
Peter Geoghegan: Add two assertions that verify the assumptions about posting list tuple space accounting and suffix truncation made within nbtsort.

doc: clarify which table creation is used for inheritance part
Bruce Momjian: Previously people might assume that the partition syntax version of CREATE TABLE is to be used for the inheritance partition table example; mention that the non-partitioned version should be used.

Fix lquery's NOT handling, and add ability to quantify non-'*' items
Tom Lane: The existing implementation of the ltree ~ lquery match operator is sufficiently complex and undocumented that it's hard to tell exactly what it does.

Implement operator class parameters
Alexander Korotkov: PostgreSQL provides set of template index access methods, where opclasses have much freedom in the semantics of indexing.

Introduce vacuum errcontext to display additional information
Amit Kapila: The additional information displayed will be block number for error occurring while processing heap and index name for error occurring while processing the index. This will help us in diagnosing the problems that occur during a vacuum.

Document color support
Peter Eisentraut: Add a documentation appendix that explains the PG_COLOR and PG_COLORS environment variables.

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

Support adding partitioned tables to publication
Peter Eisentraut: When a partitioned table is added to a publication, changes of all of its partitions (current or future) are published via that publication. This change only affects which tables a publication considers as its members.

Disk-based Hash Aggregation
Jeff Davis: While performing hash aggregation, track memory usage when adding new groups to a hash table.

Implement type regcollation
Peter Eisentraut: This will be helpful for a following commit and it's also just generally useful, like the other reg* types.

Add tg_updatedcols to TriggerData
Peter Eisentraut: This allows a trigger function to determine for an UPDATE trigger which columns were actually updated.

Allow ALTER TYPE to change some properties of a base type
Tom Lane: Specifically, this patch allows ALTER TYPE to: - Change the default TOAST strategy for a toastable base type; - Promote a non-toastable type to toastable; - Add/remove binary I/O functions for a type; - Add/remove typmod I/O functions for a type; - Add/remove a custom ANALYZE statistics functions for a type. The first of these can be done by the type's owner; all the others require superuser privilege since misuse could cause problems. The main motivation for this patch is to allow extensions to upgrade the feature sets of their data types, so the set of alterable properties is biased towards that use-case.

Show opclass and opfamily related information in psql
Alexander Korotkov: This commit provides psql commands for listing operator classes, operator families and its contents in psql.

Remove HAVE_WORKING_LINK
Peter Eisentraut: Previously, hard links were not used on Windows and Cygwin, but they support them just fine in currently supported OS versions, so we can use them there as well.

Add pg_dump support for ALTER obj DEPENDS ON EXTENSION
Alvaro Herrera: pg_dump is oblivious to this kind of dependency, so they're lost on dump/restores (and pg_upgrade).

Preserve integer and float values accurately in (de)serialize_deflist
Tom Lane: Previously, this code just smashed all types of DefElem values to strings, cavalierly reasoning that nobody would care.

Use multi-variate MCV lists to estimate ScalarArrayOpExpr
Tomas Vondra: Commit 8f321bd16c added support for estimating ScalarArrayOpExpr clauses (IN/ANY) clauses using functional dependencies.

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