CYBERTEC PostgreSQL blog. Written by experts in PostgreSQL administration, performance tuning and development. Fix slow queries and speed up your database with the most relevant knowledge for your pressing needs, fast and free.
In case you need further assistance, reach out to us, we’re happy to help.
PGconf.de 2024 in Munich
As the two talks I had submitted did not get picked for this year´s PGconf.de, my prep for the conference was all about booking train tickets from Düsseldorf to Munich. Being an early bird definitely paid off – Bernd Helmle and I enjoyed first class luxury, while our procrastinating colleagues ended up paying more for […]
Performance tuning: MAX and GROUP BY
These days everybody is talking about time series, time series analysis and alike for performance tuning. Analyzing time series data in PostgreSQL can provide valuable insights, help in making informed decisions and understanding data more deeply. By utilizing PostgreSQL’s powerful features, we can efficiently query all types of measurement data to track trends, patterns, and […]
Syslog logging with journald in PostgreSQL
Logging to syslog is not a new PostgreSQL feature at all. Still, I find few people using it, so perhaps an introductory tutorial will be helpful. Since today’s Linux distributions normally use journald for logging, I’ll focus on that. Syslog terminology Syslog is the de-facto logging standard on Unix systems. A syslog daemon receives […]
Recovering Deleted Data From PostgreSQL Tables
PostgreSQL is very good at keeping your data safe so it doesn’t disappear by itself. Unfortunately, the same holds in reverse–if data has been deleted, it stays unrecoverable. In this article, we’ll explore options for recovering deleted data from PostgreSQL tables. Option 1: cautious people use transactions If you never make any mistakes when working […]
Enforcing join orders in PostgreSQL
After the pgconfeu23 in Prague – which has been an excellent event – I decided to share some of the things I presented as a blog post to maybe shed some light on some of those topics. One of those ideas presented was the way PostgreSQL handles joins and especially join orders. Internally the PostgreSQL […]
Open source key areas for digital autonomy
How PostgreSQL is destined to make a difference at a European level Why And not just “Why”, but also how. How do you bring free and open source initiatives and something as regulated as the European Union? Both of these questions triggered me to accept the invitation to travel to Brussels and participate in this […]
TDE: A dive into encrypted data
How to check if TDE works? Some days ago a customer asked me how to check if TDE works and files on disk are encrypted. So I installed a new virtual machine with Ubuntu and installed our PGEE-Demo on it. After installation, the new created cluster is unencrypted. So we can try to create a […]
PostgreSQL to Microsoft Excel via Npgsql
This article is dedicated to all the Excel heroes out there who want to integrate and use data stored in PostgreSQL. This time we’ll cover all the steps needed to do so by utilizing Npgsql, which is an open source ADO.NET Data Provider for PostgreSQL. To learn more about this versatile driver, check out its […]
The four quadrants of an Oracle migration
The missing piece When you think about migration from Oracle to Postgres, most people just say that it is easy. And if you consult the various sources of information, nothing tells you differently. And it might not even be untrue. Most databases we create, manage, and run are easy to migrate. If you look at […]
FOSDEM 2024 in Brussels
FOSDEM 2024 and I was there! What is “FOSDEM“? In this blog post, I would like to tell you more about my visit there. FOSDEM (Free and Open Source Software Developers’ European Meeting) is the biggest Open Source event in Europe, running in Brussels since 2000, with around 5000 participants each year. No one knows […]
Postgres.AI bot interview for PGSQL Phriday #015
This month, we have an invitation from Lætitia to talk about UUIDs. UUIDs are a hot topic, and Cybertec wrote several posts earlier. I have no particular story or use case to share, and then I remembered Nikolay Samokhvalov announced the Postgres.AI bot to the public recently. I had early access to it, so I […]
Grafana dashboard for pg_timetable scheduled jobs
As a little boy, I dreamed of becoming a supersonic jet pilot or an astronaut. I also yearned to pilot trains, subways, trolleybuses, trams, and other vessels. I remember stealing pot lids from my grandparent’s kitchen to make a steering wheel. And also all sorts of devices and tools to emulate the cockpit dashboard. My […]