Magic Tricks for psql: Settings, Presets, Echo, and Saved Queries — “I wanted to share a couple of my favorite things I’ve found that make getting around Postgres better. If you’re just getting started with psql, or haven’t ventured too far out of the defaults, this is the post for you.”

Elizabeth Christensen

Render Is Your Fastest Path to Production — Whatever your stack you can build, deploy quickly, update and confidently scale your apps with ease, from the first to the billionth user. Start building with Render for free — the modern cloud for devs.

Render sponsor

Speeding Up Index Creation in Postgres — Indexes are fundamental to getting the most performance out of your queries, but it can take a long time to create new ones on large datasets. Hans-Jürgen looks at a way to significantly speed up the process.

Hans-Jürgen Schönig

You Make A Good Point! — Postgres Savepoints — Did you know that within a transaction it’s possible to define points where the remainder of the transaction can be rolled back to? They’re called savepoints.

Andrew Atkinson

Bringing Row Pattern Recognition to Postgres — The SQL standard includes an ability to search for a sequence of rows in a table based upon a defined pattern. Tatsuo is looking to bring it to Postgres too. He shows us how it works and the progress of his work.

Tatsuo Ishii

Postgres vs. Pinecone for Vector Storage and Queries — A response to a recent post from Pinecone that compared Pinecone and Postgres for vector search tasks.

Narek Galstyan

Looking for Hidden Hurdles When Postgres Faces Partitions — Andrei ran into a curious situation where partitioning a table introduced some tricky performance issues.

Andrei Lepikhov

Which Cloud Providers Support auto_explain? — auto_explain is a Postgres module for logging execution plans of slow queries automatically, but not every cloud platform supports it out of the box..

Michael Christofides

PLV8ify: Turn JavaScript Files into PLV8 Functions — Bundles TS/JS input and writes SQL containing Postgres functions using the PLV8 extension (which enables using JavaScript as a procedure language in Postgres).

Divyendu Singh