Michael Paquier - PostgreSQL committer

  • About
  • Home
  • Manuals
  • Presentations
  • Projects
  • Resume
  • Tags

Postgres 14 highlight - Monitoring for COPY

2021-06-19 01:48:55 +0000

When it comes to monitoring in PostgreSQL, progress reports, able to give the state of an operation at a given point in time, exist since 9.6 and pg_stat_process_vacuum for VACUUM. PostgreSQL 14 is adding a new feature in this area with progress reporting for COPY, as of this commit:

Read more...

Postgres 14 highlight - Memory dumps

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...

Postgres 14 highlight - REINDEX TABLESPACE

2021-05-30 06:57:01 +0000

The following feature has been committed into PostgreSQL 14, as of this commit:

Read more...

Postgres 14 highlight - Fun with Hashes

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...

Postgres 14 highlight - CREATE TABLE COMPRESSION

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...

Postgres 12 highlight - Replication slot copy

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...

Postgres 12 highlight - Recovery changes

2019-07-22 08:26:42 +0000

PostgreSQL 12 has changed the way recovery configuration works, and has introduced a couple of incompatible issues as mentioned in the main commit which has done the switch:

Read more...

Postgres 12 highlight - More progress reporting

2019-06-26 06:17:11 +0000

Since Postgres 11, it is possible to monitor progress activity of running manual VACUUM and even autovacuum using a dedicated system catalog called pg_stat_progress_vacuum. This is vital for operators when doing some long-running operations, because it is possible to not blindly wait for an operation to finish. When doing performance workload analysis, this is also proving to be helpful in evaluating VACUUM job progressing for tuning system-level parameters or even relation-level once depending on the load pattern.

Read more...

Postgres 12 highlight - SQL/JSON path

2019-06-21 03:58:34 +0000

Postgres ships in-core data types for JSON with specific functions and operators (json since 9.2, and jsonb which is a binary representation since 9.4). The upcoming Postgres 12 is becoming more compliant with the SQL specifications by introducing SQL/JSON path language, introduced mainly by the following commit:

Read more...

Postgres 12 highlight - Table Access Methods and blackholes

2019-06-04 05:16:34 +0000

Postgres is very nice when it comes to extending with custom plugins, with many set of facilities available, like:

Read more...

« Prev 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Next »

Search

Links

Github

Twitter

RSS Feeds

Main

Postgres

Unless otherwise specified, the contents of this website are (C)Copyright Michael Paquier 2010-2023 and are licensed for use under CC BY-SA 3.0.