2019-04-09 10:14:37 +0000
pg_checksums is a renaming of the tool called pg_verify_checksums which has been introduced in Postgres 11. Version 12 is introducing new options and possibilities which explain the renaming, as the tool has become much more multi-purpose.
Read more...2019-03-08 07:28:51 +0000
The maximum number of connections a PostgreSQL can accept is configured using max_connections. When attempting to connect to a server already at full capacity, logically the server complains:
Read more...2019-02-28 08:20:20 +0000
Postgres 12 is bringing a game-changer regarding common table expressions (named also CTE, defined by WITH clauses in SELECT queries) with the following commit:
Read more...2019-02-08 03:50:47 +0000
Partitions in Postgres are a recent concept, being introduced as of version 10 and improved a lot over the last years. It is complicated, and doable, to gather information about them with specific queries working on the system catalogs, still these may not be straight-forward. For example, getting a full partition tree leads to the use of WITH RECURSIVE when working on partitions with multiple layers.
Read more...2019-02-01 08:02:03 +0000
A couple of weeks ago a bug has popped up on the community mailing lists about the use of temporary objects in two-phase commit. After discussions, the result is the following commit:
Read more...Unless otherwise specified, the contents of this website are (C)Copyright Michael Paquier 2010-2025 and are licensed for use under CC BY-NC-ND 4.0.