19.7. Query Planning # 19.7.1. Planner Method Configuration 19.7.2. Planner Cost Constants 19.7.3. Genetic Query Optimizer 19.7.4. Other Planner Options 19.7.1. Planner …| PostgreSQL Documentation
24.1. Routine Vacuuming # 24.1.1. Vacuuming Basics 24.1.2. Recovering Disk Space 24.1.3. Updating Planner Statistics 24.1.4. Updating the Visibility Map 24.1.5. …| PostgreSQL Documentation
19.3. Connections and Authentication # 19.3.1. Connection Settings 19.3.2. TCP Settings 19.3.3. Authentication 19.3.4. SSL 19.3.1. Connection Settings # listen_addresses (string) # …| PostgreSQL Documentation
We continue to follow the news about PostgreSQL 18. The January CommitFest brings in some notable improvements to monitoring, as well as other new features. You can find previous reviews of PostgreSQL 18 CommitFests here: 2024-07 , 2024-09 , 2024-11 . EXPLAIN (analyze): buffers on by default pg_stat_io: input/output statistics in bytes instead of pages pg_stat_io: WAL statistics pg_stat_get_backend_io: I/O statistics for a specific process VACUUM(verbose): visibility map information Total vac...| postgrespro.com
19.6. Replication # 19.6.1. Sending Servers 19.6.2. Primary Server 19.6.3. Standby Servers 19.6.4. Subscribers These settings control the behavior of the …| PostgreSQL Documentation
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
The OAuth 2.0 authorization framework enables a third-party application to obtain limited access to an HTTP service, either on behalf of a resource owner by orchestrating an approval interaction between the resource owner and the HTTP service, or by allowing the third-party application to obtain access on its own behalf. This specification replaces and obsoletes the OAuth 1.0 protocol described in RFC 5849. [STANDARDS-TRACK]| IETF Datatracker
