Making Postgres Tick: New features in pg_cron — pg_cron is an extension that makes it easy to run periodic jobs within Postgres, with no external scheduler required. It’s not quite as advanced as pg_timetable (featured last week) but its simplicity may suit your use case better. Here, Marco shows off how pg_cron can run jobs at a granularity as fine as every second.

Marco Slot (Citus Data)

Auto Optimize Your RDS or Aurora Postgres Databases With AI — Need help optimizing Postgres knobs, queries, indexes and autovacuum? OtterTune is your AI-powered database co-pilot that can improve performance, reduce costs and keep your databases healthy. Get a free, 30-day trial for three databases.

OtterTune sponsor

Nile: A New Serverless Postgres Platform — Neon is perhaps the best known serverless Postgres platform right now, but some fresh competition is on the way. Nile’s angle is a focus on SaaS usage, supporting multi-tenant setups with seamless tenant isolation and scaling. It’s behind a waitlist, but this post goes into technical depth on their approach.

Sriram Subramanian (Nile)

SQL Identity Columns — You might also call them autoincrementing, or serial columns, but such identity columns were (eventually) standardized in SQL:2003 and Postgres has supported their GENERATED ALWAYS AS IDENTITY syntax since Postgres v10.

Peter Eisentraut

GDB Debugging Essentials with Postgres — Explore the essentials of debugging with GDB, using Postgres as a practical example. (Note: This is not needed by day-to-day Postgres users, but if you’re a C/C++ developer or working on Postgres internals, you’ll find it useful.)

Cary Huang

📅  Webinar on Nov 15: Automating Index Selection Using Constraint Programming

pganalyze sponsor

PL/Haskell 3.1: Use Haskell in Your SQL Functions — Haskell is a functional language but you can, nonetheless, use it to define procedures in such a way that Postgres can play nicely with.

Edward F. Behn, Jr.

pg_graphql 1.4.2: Bring GraphQL Support to Postgres — Reflects a GraphQL schema from the existing SQL schema, letting any GraphQL client query the database via GraphQL with no additional servers, processes, or libraries.

Supabase