20.11. Client Connection Defaults # 20.11.1. Statement Behavior 20.11.2. Locale and Formatting 20.11.3. Shared Library Preloading 20.11.4. Other Defaults 20.11.1. Statement Behavior …| PostgreSQL Documentation
The end of the March Commitfest concludes the acceptance of patches for PostgreSQL 16. Let’s take a look at some exciting new updates it introduced. I hope that this review together with the previous articles in the series ( 2022-07 , 2022-09 , 2022-11 , 2023-01 ) will give you a coherent idea of the new features of PostgreSQL 16. As usual, the March Commitfest introduces a ton of new changes. I’ve split them into several sections for convenience. Monitoring pg_stat_io: input/output stati...| postgrespro.com
We continue to follow the news of the PostgreSQL 16 release, and today, the results of the fourth CommitFest are on the table. Let’s have a look. If you missed the previous CommitFests, check out our reviews for 2022-07 , 2022-09 and 2022-11 . Here are the patches I want to talk about this time: New function: random_normal Input formats for integer literals Goodbye, postmaster Parallel execution for string_agg and array_agg New parameter: enable_presorted_aggregate Planner support function ...| postgrespro.com
We continue to follow the news of the upcoming PostgreSQL 16. The third CommitFest concluded in early December. Let's look at the results. If you missed the previous CommitFests, check out our reviews: 2022-07 , 2022-09 . Here are the patches I want to talk about: meson: a new source code build system Documentation: a new chapter on transaction processing psql: \d+ indicates foreign partitions in a partitioned table psql: extended query protocol support Predicate locks on materialized views T...| postgrespro.com
It’s official! PostgreSQL 15 is out, and the community is abuzz discussing all the new features of the fresh release. Meanwhile, the October CommitFest for PostgreSQL 16 had come and gone, with its own notable additions to the code. If you missed the July CommitFest, our previous article will get you up to speed in no time. Here are the patches I want to talk about: SYSTEM_USER function Frozen pages/tuples information in autovacuum's server log pg_stat_get_backend_idset returns the actual b...| postgrespro.com
August is a special month in PostgreSQL release cycle. PostgreSQL 15 isn't even officially out yet, but the first CommitFest for the 16th release has already been held. Let's compile the server and check out the cool new stuff!| postgrespro.com