POSETTE: An Event for Postgres 2024 | 3rd annual virtual event organized by the Postgres team at Microsoft | 48 Hours of Virtual Presentations and Meetings Starting Tue, June 11 @ 3:00 PM UTC (www.citusdata.com)
PostgreSQL Lands Support For Incremental Backups (www.phoronix.com)
Via mastodon.social/…/112220150255942506
GitHub - tatut/pgprolog: PostgreSQL Prolog language handler (github.com)
Prolog language for PostgreSQL...
PostgreSQL maintainer Simon Riggs has died in a small airplane crash (m6n.io)
PostgreSQL maintainer Simon Riggs has died in a small airplane crash, on Tuesday....
Recovering Deleted Data From PostgreSQL Tables (www.cybertec-postgresql.com)
Introducing pgzx: create PostgreSQL extensions using Zig (xata.io)
Will PostgreSQL ever change its license? | Jonathan Katz (jkatz05.com)
PostgreSQL JDBC 42.7.3, 42.6.2, 42.5.6, 42.4.5, 42.3.10, 42.2.29 Released (www.postgresql.org)
PGConf NYC 2024 - Call for Presentations (CFP) and Sponsors! (www.postgresql.org)
Request for SQL experts: Lemmy PR to combine action tables (github.com)
Lemmy currently uses distinct tables like post_like: (post_id, person_id, score) and post_saved. Unfortunately this causes performance issues when we have to join many of these tables to create views....
What’s new in the Postgres 16 query planner / optimizer (www.citusdata.com)
UUID Benchmark War (ardentperf.com)
The performance cost of pl/pgsql exception block in Postgres (dev.to)
“But how much does a PostgreSQL license actually cost?” A Frequently Asked Question from Oracle users considering PostgreSQL (stormatics.tech)
One PID to Lock Them All: Finding the Source of the Lock in Postgres (www.crunchydata.com)
Prague PostgreSQL Developer Day 2024 / Call for Papers & Sponsors (www.postgresql.org)
How we migrated our PostgreSQL database with 11 seconds downtime - Government Digital Service (gds.blog.gov.uk)
Don't Do This - PostgreSQL wiki (wiki.postgresql.org)
Waiting for Postgres 17: Incremental base backups (pganalyze.com)
We walk through the incremental backup feature committed to the Postgres 17 development branch by Robert Haas. We show an example on our local machine.
Nine ways to shoot yourself in the foot with PostgreSQL (philbooth.me)
Query Exercise: Find Posts with the Wrong CommentCount (smartpostgres.com)
Via mstdn.social/...