On 11st of December 2024, Masahiko Sawada committed patch: Add UUID version 7 generation function. This commit introduces the uuidv7() SQL function, which generates UUID version 7 as specified in RFC 9652. UUIDv7 combines a Unix timestamp in milliseconds and random bits, offering both uniqueness and sortability. In our implementation, the 12-bit sub-millisecond … Continue reading "Waiting for PostgreSQL 18 – Add UUID version 7 generation function."| select * from depesz;
We continue the series of articles about new patches coming to PostgreSQL 18, this one covering the news of the November CommitFest. If you missed the previous reviews, you can check them out here: 2024-07, 2024-09. initdb: checksum calculation enabled by default Planner: array lookup instead of multiple similar conditions under OR Planner: switching around expressions in DISTINCT clauses GROUPING SETS: HAVING -> WHERE Data type cache entry invalidation and temporary tables Planner: incremen...| Postgres Professional Europe Limited
Statistically, September CommitFests feature the fewest commits. Apparently, the version 18 CommitFest is an outlier. There are many accepted patches and many interesting new features to talk about. If you missed the July CommitFest, get up to speed here: 2024-07. Conflict detection and logging in logical replication Planner: no more 10000000000 Planner: memory management and usage monitoring for temporary tuple storage Reading buffers during index backwards scan pg_upgrade: asynchronous oper...| Postgres Professional Europe Limited
This article is the first in the series about the upcoming PostgreSQL 18 release. Let us take a look at the features introduced in the July CommitFest. Planner: Hash Right Semi Join support Planner: materializing an internal row set for parallel nested loop join Planner support functions for generate_series EXPLAIN (analyze): statistics for Parallel Bitmap Heap Scan node workers Functions min and max for composite types Parameter names for regexp* functions Debug mode in pgbench pg_get_backen...| Postgres Professional Europe Limited
19.4. Resource Consumption # 19.4.1. Memory 19.4.2. Disk 19.4.3. Kernel Resource Usage 19.4.4. Background Writer 19.4.5. I/O 19.4.6. Worker Processes 19.4.1. Memory …| PostgreSQL Documentation
On 22nd of January 2025, Tom Lane committed patch:| select * from depesz;
On 16th of January 2025, Dean Rasheed committed patch:| select * from depesz;
On 6th of January 2025, Nathan Bossart committed patch:| select * from depesz;
On 11st of December 2024, David Rowley committed patch:| select * from depesz;
On 18th of December 2024, Michael Paquier committed patch:| select * from depesz;
This specification defines UUIDs (Universally Unique IDentifiers) -- also known as GUIDs (Globally Unique IDentifiers) -- and a Uniform Resource Name namespace for UUIDs. A UUID is 128 bits long and is intended to guarantee uniqueness across space and time. UUIDs were originally used in the Apollo Network Computing System (NCS), later in the Open Software Foundation's (OSF's) Distributed Computing Environment (DCE), and then in Microsoft Windows platforms. This specification is derived from t...| IETF Datatracker
