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 […]
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 […]
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 […]
PGSQL Phriday #014: PostgreSQL Events
As PostgreSQL enthusiasts, we all know that the community’s heartbeat lies in PostgreSQL Events, whether local meetups, big conferences, or virtual gatherings, that have become prevalent during the COVID-19 pandemic. During a thrilling conference season, the PostgreSQL community is abuzz with activity. We’ve just wrapped up the PASS Data Community Summit, which featured a dedicated […]
Introducing pg_timetable v5.6: delayed chains and error handling
We’re excited to unveil pg_timetable v5.6, a significant release that takes your PostgreSQL job scheduling to a new level. In this release, we’ve introduced several key enhancements and features that empower you to manage and automate your database tasks precisely and flexibly. Start async chains with delay One of the standout features in pg_timetable v5.6 […]
PGDay Belgium 2023 reflections
Introduction As a senior database consultant and developer at CYBERTEC PostgreSQL International, I recently enjoyed presenting at PGDay Belgium 2023 at the UCLL campus Proximus in Haasrode. “Professional PostgreSQL Monitoring Made Easy” During my talk at PGDay Belgium 2023, I had the opportunity to delve into the world of professional PostgreSQL monitoring. I explored best […]
LZ4 and ZSTD pg_dump compression in PostgreSQL 16
LZ4 and ZSTD pg_dump compression I wrote a “pg_dump compression specifications in PostgreSQL 16” post a while ago. Frankly speaking, I thought new compression methods would not be implemented in PostgreSQL until 2-3 years from now. Probably demand is so high that LZ4 and ZSTD made their way into PostgreSQL 16! The LZ4 patch author […]
Underscores in numeric constants in PostgreSQL 16
SQL and numeric constants NEW in PostgreSQL 16 – support for underscores in integer and numeric constants! I already wrote about support for different notations in the upcoming PostgreSQL 16. This new major version also implements the SQL:202x standard (draft), allowing you to use underscore separators for integers and numeric constants. Using underscore separators in […]
Parallel aggregate – PostgreSQL 16 – better performance
What is a parallel aggregate? In PostgreSQL, a parallel aggregate refers to a way of processing aggregate functions (such as SUM, AVG, MAX, MIN, etc.) on large amounts of data in a parallel and distributed manner, thereby making the query execution faster. When executing an aggregate query, the database system automatically breaks up the result […]
New old “debug_parallel_query” setting in PostgreSQL 16
Naming variables Why will force_parallel_mode – the runtime option be renamed to debug_parallel_query in PostgreSQL 16? Proper variable and function naming play a vital role in making code understandable, maintainable, and easily shareable. When we give our variables descriptive names that reflect their purpose, it becomes much simpler for others to understand our code, follow […]
pg_timetable v5.3 is out!
Our team is proud to introduce a new pg_timetable v5.3 release! This time we focused solely on implementing new features for logging. I want to remind you that pg_timetable is a community project. So, please, don’t hesitate to ask any questions, to report bugs, to star the pg_timetable project, and to tell the world about […]