Recent Articles - PostgreSQL

Automatic Audit Logging with PostgreSQL Triggers

Dec 12, 2024 · 10 min read

You can create an automatic audit log of changes to a table's rows by using functions, triggers, and a second table.

databases postgres

---

Deferrable Constraints in PostgreSQL

Jun 20, 2022 · 9 min read

Constraints in PostgreSQL are validated immediately row-by-row by default, which might be confusing when updating multiple values in columns that have a uniqueness constraint.

databases postgres

---

Creating a PostgreSQL REPL Playground in Docker

Apr 27, 2022 · 3 min read

It's helpful to have local throwaway environments for rapid development, especially with databases, and creating one for PostgreSQL is a snap with Docker.

databases docker postgres

---

Finding Long-Running Queries in PostgreSQL

Nov 26, 2021 · 2 min read

Poorly optimized queries and excessive connections can cause problems in PostgreSQL, here's a quick way to identify and kill them.

databases postgres

---

Calculating Table Size in PostgreSQL

Nov 26, 2021 · 2 min read

Knowing how much disk space individual tables take up is important for DB maintenance and debugging, and it can be accomplished with a single query in PostgreSQL.

databases postgres