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.
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 […]
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
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 […]
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 […]