PostgreSQL Support Senior (full-time, Germany and Würzburg)

We are looking for two experienced Senior PostgreSQL Support Database Engineers based in Germany and in Würzburg (Germany) to lead and expand our Support Operations team. Responsibilities: Lead the design, implementation, and maintenance of PostgreSQL databases in Kubernetes environments using operators. Provide expertise in database performance tuning, query optimization, and high availability solutions, including Patroni. […]

Read more

PostgreSQL parallel query problems in JDBC and DBeaver

  I recently investigated a surprising behavior of the DBeaver database client in connection with PostgreSQL parallel query, which I’d like to share with you. This might be interesting for everybody who accesses PostgreSQL using the JDBC driver. Some basics about PostgreSQL parallel query Parallel query concepts Parallel query was introduced in PostgreSQL 9.6 and […]

Read more

Optimizing PostgreSQL functions with preloaded libraries

In PostgreSQL, functions and procedures can be written in many different programming languages including but not limited to PL/pgSQL, PL/Perl, PL/Python and a lot more. This flexibility gives the end user the choice to write code in languages of their choice. However, this flexibility has some implications which are often forgotten. Loading libraries early is one […]

Read more

Kill long running queries in PostgreSQL

How to terminate long running queries in PostgreSQL: People might be fans of SQL, people might like PostgreSQL on Kubernetes or people might even love database ORMs. But have you ever heard of a single person who loves slow queries? In 20+ years of professional database engineering, I have not seen a single fan club […]

Read more

Migrate from Sybase to PostgreSQL

In 1987, Sybase Adaptive Server Enterprise (Sybase ASE, now SAP ASE) was released to the public, and was adopted by a fair number of users over the years. However, nothing lasts forever; SAP has announced the end of mainstream maintenance (EoMM) by 2025. Sybase ASE is dead. Those still using Sybase face the need to […]

Read more