DEV Community

#postgres

Posts on tips and tricks, using and learning about PostgreSQL for database development and analysis.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
200 admins opened the dashboard at once. It took 9.8 seconds.

200 admins opened the dashboard at once. It took 9.8 seconds.

Comments
4 min read
How to get correct SQL from AI: give it the schema, the dialect, and EXPLAIN

How to get correct SQL from AI: give it the schema, the dialect, and EXPLAIN

Comments
5 min read
Two migrations, one table, and a journal whose timestamps describe a database that no longer exists

Two migrations, one table, and a journal whose timestamps describe a database that no longer exists

Comments
6 min read
Best Tools to Sync Xero Data to a Database (2026)

Best Tools to Sync Xero Data to a Database (2026)

Comments
9 min read
Your upsert can preserve an offer that never existed

Your upsert can preserve an offer that never existed

Comments 2
9 min read
Docker health checks that catch real problems, explained simply

Docker health checks that catch real problems, explained simply

3
Comments
9 min read
My 3-layer agent session locking fix stopped it from quietly wrecking customer records

My 3-layer agent session locking fix stopped it from quietly wrecking customer records

Comments
7 min read
docker compose depends_on does not wait for your database: fix "connection refused" on startup with healthchecks

docker compose depends_on does not wait for your database: fix "connection refused" on startup with healthchecks

Comments 1
2 min read
23% Faster Autovacuum with Parallel Workers in PostgreSQL 19

23% Faster Autovacuum with Parallel Workers in PostgreSQL 19

Comments
5 min read
PostgreSQL Constraint Naming Convention: Which Pattern to Use, and How to Find the Names That Drifted

PostgreSQL Constraint Naming Convention: Which Pattern to Use, and How to Find the Names That Drifted

Comments
8 min read
Your retrieval log is not an audit trail. I checked six Supermemory alternatives for one.

Your retrieval log is not an audit trail. I checked six Supermemory alternatives for one.

Comments
7 min read
A school discount with no code, because the discount is the email domain

A school discount with no code, because the discount is the email domain

Comments 1
4 min read
Airbyte vs Estuary for Postgres to Snowflake Replication

Airbyte vs Estuary for Postgres to Snowflake Replication

15
Comments 2
6 min read
Go: January 31 plus one month is March 3

Go: January 31 plus one month is March 3

Comments
6 min read
Pgpool-II client certificate validation bypass: what CVE-2026-92868 changes

Pgpool-II client certificate validation bypass: what CVE-2026-92868 changes

Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.