PGXpertise™ lets you have a world-leading PostgreSQL Expert on call. This is a monthly retainer service that provides a block of consulting hours that can be used for any service PGX provides, at a significant discount. Contact us today!

https://pgexperts.com/services/pgxpertise

#PostgreSQL #postgres

It Depends: Using Session Variables in Postgres

Postgres has supported session variables since 2012. This PG Phriday with Shaun Thomas covers set_config, current_setting, and a working multi-tenant RLS example

One week from today, Boston PUG will be hosting their next in-person event! Join them for “Sharding Postgres with the Citus Extension: Tradeoffs and Early Lessons” with Alex Adriaanse and Iñaki Serraller Vizcaino.

https://www.meetup.com/boston-postgresql-users-group-bpug/events/313944162/?eventOrigin=network_page

#PostgreSQL #postgres

postgres in production — on 4grab.com connection pooling, backups, indexes, replication. the practical stuff nobody teaches you until something breaks in prod. https://4grab.com/pay.php?id=ptag_69c42fd50e92a #prompt #postgres #database #devops
PostgreSQL in Production: Pooling, Backups, Indexes, Replication — Purchase

pg_statviz 1.0 is out: New! Improved! Now with AI! (Optional, of course.) Per-chart verdicts and remediation for your PostgreSQL stats.

https://vyruss.org/blog/pg_statviz-1-0-released-ai-analysis.html

#PostgreSQL #Postgres #pg_statviz #AI #viz #dataviz

pg_statviz 1.0 released with AI-powered analysis

Extension pg_statviz for time series analysis & visualization of Postgres internal statistics has released version 1.0 with an optional AI analysis mode that produces per-module HTML reports with chart commentary, threshold verdicts, and concrete remediation advice from a cloud or local LLM.

-=vyruss=- / blog

Launch HN: Ardent (YC P26) - Postgres sandboxes in seconds with zero migration

https://www.tryardent.com/

#HackerNews #Tech #Postgres

Ardent — Database branching for coding agents

Create copies of any Postgres database in under 6 seconds. Let coding agents test, clean, and migrate data on isolated branches with zero risk to production.

Ardent

Launch HN: Ardent (YC P26) – Postgres sandboxes in seconds with zero migration

https://www.tryardent.com/

#HackerNews #LaunchHN #Ardent #Postgres #Sandboxes #YCombinator #TechNews

Ardent — Database branching for coding agents

Create copies of any Postgres database in under 6 seconds. Let coding agents test, clean, and migrate data on isolated branches with zero risk to production.

Ardent
All Your GUCs in a Row: authentication_timeout

A connection is not free just because it has not logged in yet. From the moment the TCP handshake completes, the would-be client is holding a backend slot count

Calling all women in Postgres and Allies! Stacey Haysler and Mila Zhou will be hosting the Postgres Women's Breakfast next Wednesday, May 20th, at PGConf DEV! That’s one week from today!

RSVP here: https://tinyurl.com/pgwbdev2026

#PostgreSQL #postgres

Explore real-world PostgreSQL lessons with Hajira Sultana at PG DATA 2026 on June 4!

In “What I Learned Using PostgreSQL In Real Products,” Hajira shares practical insights from building and scaling full-stack applications with PostgreSQL 🐘

Join us: https://2026.pg-data.org/

#PGData #PGData2026 #PostgreSQL #Postgres #FullStack #DBA #OpenSource #SQL #DataEngineering