PostgreSQL has gained two features that help in getting information about the memory usage of sessions. First, as of this commit, there is one new system view that reports the memory usage for a session:
Read more...2021-06-06 06:42:22 +0000
PostgreSQL has gained two features that help in getting information about the memory usage of sessions. First, as of this commit, there is one new system view that reports the memory usage for a session:
Read more...2021-05-30 06:57:01 +0000
The following feature has been committed into PostgreSQL 14, as of this commit:
Read more...2021-05-23 12:58:12 +0000
PostgreSQL has a long history with cryptographic hashes, coming into three parts, roughly. First, MD5 authentication, that exists in PostgreSQL since 2001 in this commit. This feature has come up with its own implementation of this hash in either src/common/md5.c or src/backend/libpq/md5.c, depending on the branch of the code checked out. This is then used by libpq or the backend code. One thing to know is that this code gets used even when building PostgreSQL with OpenSSL, library that has its own APIs to be able to build MD5 hashes.
Read more...2021-05-15 13:06:22 +0000
It has been some time since something has been posted on this blog, and here is a short story about the following commit, for a feature that will land in the upcoming version 14 of PostgreSQL:
Read more...2019-07-29 07:54:51 +0000
Replication slots can be used in streaming replication, with physical replication slots, and logical decoding, with logical replication slots, to retain WAL in a more precise way than wal_keep_segments so as past WAL segments are removed at checkpoint using the WAL position a client consuming the slot sees fit. A feature related to replication slots has been committed to PostgreSQL 12:
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.