.:\dGh/:.6h ago

Another fucking year.

Another #PostgreSQL version without MIN/MAX aggregators for fucking UUID v7 (or an exclusive, UUID-v7-type-column)

Thank you.

#Programming #Coding #Code #PgSQL #Postgre #SQL #Database #Databases #RDBM #RDBMS #DB #UUID #UUIDv7 #SoftwareDevelopment #WebDevelopment #WebDev #AppDevelopment #AppDev

dan slimmonDec 12, 2023

Quick rundown of the MultiXact: a #PostgreSQL locking implementation detail that you can absolutely ignoreโ€ฆ until suddenly you can't anymore ๐Ÿ”’๐Ÿ’€

https://blog.danslimmon.com/2023/12/11/concurrent-locks-and-multixacts-in-postgres/

#postgres #rdbm #mvcc #databases #sql

Concurrent locks and MultiXacts in Postgres

Pretty recently, I was troubleshooting a performance issue in a production Rails app backed by Postgres. There was this one class of query that would get slower and slower over the course of about โ€ฆ

Dan Slimmon
Ollivier Robert ๐Ÿ‡บ๐Ÿ‡ฆ๐Ÿ˜ท๐ŸŒˆโ™พ๏ธMay 18, 2017

Postgres 10 Beta 1 is now out: logical replication, native partitioning, and more: https://www.postgresql.org/about/news/1749/

#postgres #rdbm