Database management

Improve your development experience in PostgreSQL’s PL/pgSQL by using plpgsql_check

In the last post we’ve highlighted some tips when developing functions and/or procedures in PostgreSQL’s PL/pgSQL. Especially the Compile-Time and Run-Time checks can save you a lot of work and give you important hints while(…)

Some tips when developing in PostgreSQL’s PL/pgSQL

When you develop functions or procedures in PostgreSQL’s PL/pgSQL there are some points to consider, which make your life easier. This post is not about control structures,(…)

2022.pgconf.eu Berlin conference for tech

Last week, the biggest European PostgreSQL event of the year took place in Berlin (2022.pgconf.eu). This event is an excellent opportunity to meet developers from the PostgreSQL community and to attend high profile tech presentations. Tuesday evening(…)

Patching ODA HA from 19.14 to 19.16

By Mouhamadou Diaw Patching an ODA is always exciting. Preparing a patch of an ODA HA may seem more complicated that an single ODA. But it’s the same processus. All patching operations should be run on(…)

Setup a PostgreSQL Instance in Google Cloud SQL

This blog will be the first of a series of blogs, to report about my experiences with Google Cloud SQL. In this blog we will setup a basic PostgreSQL instance in the Google Cloud. If you’re new to(…)

Oracle Exchange Partition

The Oracle Exchange Partition is a method allowing to : exchange the data segments from a non partitioned table to a partitioned table exchange the data segments from a partitioned table to a non partitioned table. This method(…)

Meson vs. make: PostgreSQL build and test times

In the last post we’ve looked into how you can build PostgreSQL with Meson instead of the traditional way using configure/make. The reason for this was a(…)

Building PostgreSQL with Meson

Last year, around this time, there started a thread on hackers which was about building PostgreSQL with meson. I didn’t know anything about Meson at this time, and don’t know much(…)

Oracle Database Row Archiving

In a recent customer project, I was suffering to delete millions of rows from a LOG table. Removing 3 months of data took more than 30 minutes with the best optimization possible. After a while, I remembered(…)

PostgreSQL from packages on NetBSD

The last flavor of BSD we’ll look at is NetBSD. We already had FreeBSD (here and here) and OpenBSD (here and(…)