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.
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 […]
PostgreSQL: Why true Open Source matters
PGConfEU2023 is over and a New Year has started. For those who did not manage to make it to Prague to attend the conference, I wanted to use the occasion, to sum up what I tried to communicate during my keynote session and reflect a bit on the importance of true Open Source versus Closed […]
PostgreSQL parallel query problems in JDBC and DBeaver
© Laurenz Albe 2024 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 […]
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 […]
Cloud Services and Fully Managed Postgres
The Cloud is here There is no getting around “The Cloud”. We all know it, everybody is doing it! And, let’s face it, if you are looking to get away from the hardship of having to go through troublesome and boring processes to get a new server or a new rack installed in your data […]
The Golden Trunk 2023 Award: My Playful Ode to Bloggers
Because Who Needs Another Gold Statue Anyway? In the world of databases, where seriousness often reigns supreme… Well, you know me! I always want to inject a bit of humor and fun. Welcome to the inaugural “Golden Trunk 2023” award – my impulsive celebration of PostgreSQL community brilliance, where a golden elephant trunk steals the […]
The 2023 PGconf.EU in Prague
Most of CYBERTEC’s employees are spread over central and Eastern Europe, so we rarely get to see each other in person, except for the ubiquitous video calls that have become common nowadays. Going to conferences is the best way to meet, and among them, the annual PGconf.EU conference is the best and biggest opportunity. This […]
Broken foreign keys: how can that happen in PostgreSQL?
© Laurenz Albe 2023 One of the fundamental requirements for a relational database is that the transaction system always maintains consistency. That means that database constraints must always be satisfied, even in the face of concurrent data modifications. PostgreSQL certainly strives to live up to this requirement. Still, you can end up with broken foreign […]
Reflections on PGConf.eu 2023
Anticipation Coming to Prague was something that had been in my planning for quite a while. And what should have been a smooth preparation, turned into a fascinating journey. As I dare consider myself a part of this fantastic PostgreSQL community, skipping PGConf.EU 2023 would be an impossible thought. Thanks to CYBERTEC and the personal […]
PostgreSQL hash index performance
© Laurenz Albe 2023 Among the many index types in PostgreSQL, the hash index is the most widely ignored. This came home to me when somebody asked me a question about hash index performance recently. High time to explore that little-known corner of PostgreSQL and run some benchmarks! The history of the hash index PostgreSQL […]
What you should know about PostgreSQL minor upgrades
© Laurenz Albe 2023 The PostgreSQL documentation is rather terse on the subject of minor upgrade. The reason is probably that the procedure is so simple. Still, I find that many people don’t understand this topic well, so I thought I should compile the relevant information in an article. What is a PostgreSQL minor upgrade? […]
PGSQL Phriday #014: Wrapping up!
PGSQL Phriday #014: PostgreSQL Events In my PGSQL Phriday #014 welcome post, I invited everyone to share their PostgreSQL event experiences in a dedicated blog post on December 1st. I am thrilled many people liked the idea and pitched in to make this event happen. Thanks to everyone! PostgreSQL at AWS re:Invent by Franck Pachot […]