PostgreSQL

Postgresql Security with Builtin Roles and functions.

Introduction As PostgreSQL continues to gain traction in enterprise-grade applications, I am increasingly tasked and asked about implementing robust security policies. And, as most current DBA positions are multi-systems nowadays, I wanted to make a quick summary on roles and(…)

PostgreSQL: Maybe we should give ZFS a chance (1) – baseline

Recently I’ve switched my PostgreSQL playground from Linux to FreeBSD. Not because I don’t like Linux anymore, just because I like trying out other operating systems and see what works the same and what is different.

PostgreSQL: Partitioning an existing table (almost) online using table inheritance

The PostgreSQL mailing list archives are a wonderful place to get new ideas just by reading through random posts. This time I found an interesting idea on how to partition an existing(…)

PostgreSQL: Delaying authentication to debug a process

While investigating a customer issue (details here) one of the replies suggested to use pre_auth_delay to add a delay before a session is authenticated. Even if this was not useful for the actual issue, this(…)

PostgreSQL Conference Europe 2024 – Last day

As I reflect on my last day at PGConf.EU 2024 in the beautiful city of Athens, I am filled with a profound sense of gratitude and excitement. The conference was a melting pot of innovation, knowledge sharing, and community spirit,(…)

2024.pgconf.eu – Bigger than ever, the family is growing fast

The PostgreSQL community is growing every year and the same happens for pgconf.eu, which happened in Athens, Greece, this year. Attending this event is one of the best opportunities to get in touch with the people behind PostgreSQL. This year(…)

PostgreSQL Conference Europe 2024 – Day 2

Here’s the following day 2 of the PostgreSQL Conference Europe 2024 in Athens, if you haven’t read the first day here is the link. After a fantastic first day, I was excited to dive into the next day of(…)

PostgreSQL Conference Europe 2024 – Day 1

Attending PostgreSQL Conference Europe 2024 in Athens is an incredible experience, full of enriching conversations and technical deep dives. As a DBA Consultant and speaker (on the reserve list and honored to have been chosen), it was my first time(…)

PostgreSQL 17: Enhancing JSON Support for Web Developers

PostgreSQL 17 introduces new features for working with JSON data. These features align PostgreSQL more closely with the SQL/JSON standard and improve the developer experience when dealing with semi-structured data. In this blog, we will explore the new JSON capabilities(…)

Improved not null/null planning in PostgreSQL 17

PostgreSQL 17 came with quite some additional features for the optimizer. One of them is about “is null” and “is not null” handling when column have a “not null” constraint defined. In the past it was(…)