My DBA Notebook

Postgres women founder, PostgreSQL Europe treasurer, PostgreSQL recognized contributor.
Practice Leader, Postgres & Security at EDB.
Opinions are my own.

2024

Jun 5

A Tuning Guide: a good starting point

PostgreSQL Administration Performance

Feb 3

PGSQL Phriday #015: Primary keys: UUID, CUID, or TSID?

PGSQL Phriday PostgreSQL

Jan 27

PGSQL Phriday #015: UUID: let's fight!

PGSQL Phriday PostgreSQL

2023

Jul 7

PGSQL Phriday #010: Log analysis

PGSQL Phriday PostgreSQL

Apr 21

Triggers: reading other opinions

PGSQL Phriday PostgreSQL

Apr 7

Triggers and me

PGSQL Phriday PostgreSQL

Mar 30

Triggers

PGSQL Phriday PostgreSQL

Mar 3

Postgres documentation explained

Documentation PostgreSQL

Feb 1

is it a bug?

PostgreSQL SQL Standard

Jan 2

Don't do this: creating useless indexes

PostgreSQL Administration PGSQL Phriday

2022

Nov 4

How to do proper backups

PostgreSQL PGSQL Phriday Administration

Oct 7

2 it depends and one absolutely always do this!

PostgreSQL psql PGSQL Phriday

Oct 6

PGConfEU: My ideal schedule

PostgreSQL event

Sep 24

Preferred types

Internals PostgreSQL

Sep 22

Taking children to PostgreSQL Conference Europe

PostgreSQL event

May 21

Removing some pedantry off Postgres

Hacking PostgreSQL

2021

Sep 30

3 ways to auto-increment with Postgres

Administration PostgreSQL

Sep 23

My Postgres environment

PostgreSQL

Sep 17

pglog, a flexible and simple log analyzer

Administration PostgreSQL

Apr 4

A Tip a day takes the GUI away!

Administration PostgreSQL

Mar 21

No space left on device

Administration PostgreSQL Troubleshooting

Mar 16

Why I did not write that patch

Hacking PostgreSQL

Feb 26

Simply auditing your database changes

Administration PostgreSQL

Jan 29

The vicious circle of huge writes

PostgreSQL Administration

2020

Dec 16

Replica identity for logical replication

PostgreSQL Administration

Dec 1

Is my port open?

PostgreSQL Administration

Nov 27

Postgres dress with pockets

PostgreSQL

Apr 19

Where do my Postgres settings come from ?

Hacking PostgreSQL Administration

Apr 4

Debian Default Logging Explained

Hacking PostgreSQL Debian

Mar 30

Can't connect to Postgres

Administration PostgreSQL Troubleshooting

Mar 24

Restoring Through timeline change

Installation PostgreSQL

Mar 22

What's wrong with Postgres?

Administration PostgreSQL Troubleshooting

Mar 20

Is Postgres running ?

Administration PostgreSQL Troubleshooting

Feb 2

The fsync issue and Postgres

Hacking PostgreSQL

2019

Oct 22

SSO on Postgres with Active Directory : troubleshooting

Administration PostgreSQL

Sep 7

Managing conf files

Administration PostgreSQL

Mar 25

Interacting with Postgres community

PostgreSQL Hacking

Jan 31

Adding your patch to the next commitfest

PostgreSQL Hacking

Jan 23

Testing replication connections

PostgreSQL Administration

Jan 16

Regression tests

PostgreSQL Hacking

Jan 11

Working with git

Hacking PostgreSQL

2018

Dec 14

Patching Postgres' Documentation

Hacking PostgreSQL Documentation

Dec 12

Adding log10() to PostgreSQL

Hacking PostgreSQL