postgresql

Data Migration with OMrun – Migration (part II)

In many cases, you need a data migration from an existing on-premises databases to the cloud. Not only is it necessary to move your data, but often you also need to change the technology stack. In addition, it is(…)

PostgreSQL 16: More statistics in pg_stat_*_tables

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,(…)

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

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(…)

How a merge join produced the wrong result in PostgreSQL

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(…)

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

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(…)

pgDay Paris 2023

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.

Microsoft Flexible Server Compute V5

Today I had the chance to move forwar with performance testing and some checks on two Flexible Server – Azure Database for PostgreSQL, one with 8vCPU, 64GB RAM and 512GB Storage (2300 IOPs) and another one with the same(…)

Flexible Server for PostgreSQL, Status March 2023

As many know about a year ago I wrote some critical posts about Microsofts Flexible Server for PostgreSQL, now it is time to take a look again. At first, many promised functions where delivered with a latency of(…)

More compression options for pg_dump in PostgreSQL 16

The last releases of PostgreSQL already introduced new options for compression, see here and here. PostgreSQL 16 will build on top of that and will come with(…)

Converting from Unix timestamps to “real” timestamps in PostgreSQL

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(…)