BE SHARING

Daniel Westermann

PostgreSQL 16: More statistics in pg_stat_*_tables

05.06.2023 by Daniel Westermann

PostgreSQL 16 is already in feature freeze and Beta1 has been released on May 25th. This is the time you should start testing and report any issues back to the community. There are plenty of new features, as usual, and(…)

Database Administration & Monitoring

2023.pgconf.de and the Swiss PGDay are just around the corner

02.06.2023 by Daniel Westermann

Time flies, we are in June already and at the end of this month two PostgreSQL conferences will take place: There is 2023.pgconf.de, this year in Essen, the 27th of June. For the first time in(…)

Database Administration & Monitoring

How a merge join produced the wrong result in PostgreSQL

14.04.2023 by Daniel Westermann

This was a really interesting customer case and I learned a lot by troubleshooting this. The original request was: We have two databases connected via postgres_fdw and when a merge join is chosen by PostgreSQL we(…)

Database Administration & Monitoring

PostgreSQL 16: GENERIC_PLAN option for EXPLAIN and SHELL exit codes for psql

27.03.2023 by Daniel Westermann

Last week some smaller features got committed for PostgreSQL. The first one is an option which can be given to explain for displaying the generic plan for a statement. I’ve written about generic plans in the past, please read(…)

Database Administration & Monitoring

pgDay Paris 2023

24.03.2023 by Daniel Westermann

Another great PostgreSQL community conference is over, and I came back with a lot of impressions yesterday. It was probably the worst time of the year for the conference to happen, as massive strikes are ongoing in France currently. Nothing(…)

Database Administration & Monitoring

Starting PostgreSQL logical replication for some tables based on a dump

02.03.2023 by Daniel Westermann

Recently at a customer we faced a somehow strange issue: We’ve setup logical replication from a public cloud managed PostgreSQL service to a PostgreSQL instance on a VM hosted by the same public cloud provider. For most of the tables(…)

Database Administration & Monitoring

PostgreSQL 16: More I/O statistics

14.02.2023 by Daniel Westermann

PostgreSQL is already tracking various kinds of statistics which can help in identifying bottlenecks. Some of these statistics are available in the the pg_statio_* catalog views: postgres=# select viewname from pg_views where viewname like '%statio%'; viewname -------------------------- pg_statio_all_sequences pg_statio_all_tables pg_statio_sys_tables(…)

Database Administration & Monitoring

PostgreSQL 16: reserved_connections

22.01.2023 by Daniel Westermann

The maximum number of connections that PostgreSQL will allow, is controlled by the max_connections parameter. By default this allows a maximum of one hundred connections: postgres=# show max_connections; max_connections ----------------- 100 (1 row) In reality not one hundred connections(…)

Database Administration & Monitoring

Converting from Unix timestamps to “real” timestamps in PostgreSQL

13.01.2023 by Daniel Westermann

Recently we’ve been asked how an application can be changed from using Unix timestamps to PostgreSQL timestamps. It is still not so uncommon to store dates and times in numeric data types,(…)

Daniel Westermann

PostgreSQL 16: More statistics in pg_stat_*_tables

2023.pgconf.de and the Swiss PGDay are just around the corner

How a merge join produced the wrong result in PostgreSQL

PostgreSQL 16: GENERIC_PLAN option for EXPLAIN and SHELL exit codes for psql

pgDay Paris 2023

Starting PostgreSQL logical replication for some tables based on a dump

More compression options for pg_dump in PostgreSQL 16

PostgreSQL 16: More I/O statistics

PostgreSQL 16: reserved_connections

Converting from Unix timestamps to “real” timestamps in PostgreSQL