PostgreSQL
PostgeSQL is a leading open-source SQL database server.
www.postgresql.org
Recent Activity
- Avoid unnecessary "touch meson.build" in vpath builds
Andres Freund: In e6927270cd1 I added a 'touch meson.build' to configure.ac, to ensure conflicts between in-tree configure based builds and meson builds are automatically detected. - Post-commit review fixes for slot synchronization
Amit Kapila: Allow pg_sync_replication_slots() to error out during promotion of standby. - pg_combinebackup: Add --version to --help output
Peter Eisentraut: (It was already on the man page. - Support disallowing SSL renegotiation when using LibreSSL
Daniel Gustafsson: LibreSSL doesn't support the SSL_OP_NO_RENEGOTIATION macro which is used by OpenSSL, instead it has invented a similar one for client-side renegotiation: SSL_OP_NO_CLIENT_RENEGOTIATION. - Remove some unnecessary fields from executor nodes
Tom Lane: JsonExprState.input_finfo is only assigned to, never read, and it's really fairly useless since the value can be gotten out of the adjacent input_fcinfo field. - Better handle indirect constraint drops
Alvaro Herrera: It is possible for certain cases to remove not-null constraints without maintaining the attnotnull in its correct state; for example if you drop a column that's part of the primary key, and the other columns of the PK don't have not-null constraints, then we should reset the attnotnull flags for those other columns; up to this commit, we didn't. - Ensure generated join clauses for child rels have correct relids
Tom Lane: When building a join clause derived from an EquivalenceClass, if the clause is to be used with an appendrel child relation then make sure its clause_relids include the relids of that child relation. - psql: Make output of \dD more stable
Peter Eisentraut: \dD showed domain check constraints in arbitrary order, which can cause regression test failures, which was exposed by commit 9895b35cb8. - Revert: Custom reloptions for table AM
Alexander Korotkov: This commit reverts 9bd99f4c26 and 422041542f per review by Andres Freund. - Doc: Update ulinks to RFC documents to avoid redirect
Daniel Gustafsson: The tools.ietf.org site has been decommissioned and replaced by a number of sites serving various purposes.
Most Popular In The Past Month
- Optimize pg_popcount() with AVX-512 instructions
Nathan Bossart: Presently, pg_popcount() processes data in 32-bit or 64-bit chunks when possible. - Add support for MERGE ... WHEN NOT MATCHED BY SOURCE.
Dean Rasheed: This allows MERGE commands to include WHEN NOT MATCHED BY SOURCE actions, which operate on rows that exist in the target relation, but not in the data source. - Enhance nbtree ScalarArrayOp execution
Peter Geoghegan: Commit 9e8da0f7 taught nbtree to handle ScalarArrayOpExpr quals natively. - Add basic JSON_TABLE() functionality
Amit Langote: JSON_TABLE() allows JSON data to be converted into a relational view and thus used, for example, in a FROM clause, like other tabular data. - Allow specifying initial and maximum segment sizes for DSA.
Masahiko Sawada: Previously, the DSA segment size always started with 1MB and grew up to DSA_MAX_SEGMENT_SIZE. - Introduce a non-recursive JSON parser
Andrew Dunstan: This parser uses an explicit prediction stack, unlike the present recursive descent parser where the parser state is represented on the call stack. - JSON_TABLE: Add support for NESTED paths and columns
Amit Langote: A NESTED path allows to extract data from nested levels of JSON objects given by the parent path expression, which are projected as columns specified using a nested COLUMNS clause, just like the parent COLUMNS clause. - Add support for incrementally parsing backup manifests
Andrew Dunstan: This adds the infrastructure for using the new non-recursive JSON parser in processing manifests. - Provide API for streaming relation data
Thomas Munro: Introduce an abstraction allowing relation data to be accessed as a stream of buffers, with an implementation that is more efficient than the equivalent sequence of ReadBuffer() calls.
Client code supplies a callback that can say which block number it wants next, and then consumes individual buffers one at a time from the stream. - Add built-in ERROR handling for archive callbacks
Nathan Bossart: Presently, the archiver process restarts when an archive callback ERRORs.