#postgresmarathon search results

Nikolay Samokhvalov (@samokhvalov): #PostgresMarathon 2-006: Mysterious max_locks_per_transaction postgr.es/p/7iN

X doesn't let me post #PostgresMarathon 2-006 -- some bug blocks the piece I wrote. Going to post somehow else.

Nikolay Samokhvalov (@samokhvalov): #PostgresMarathon 2-005: More LWLock:LockManager benchmarks for Postgres 18 postgr.es/p/7iJ

#PostgresMarathon 2-005 More LWLock:LockManager benchmarks for Postgres 18 In 2023-2024, after incidents that multiple customers of PostgresAI experienced, when production nodes were down because of LWLock:LockManager contention, we studied it in synthetic environments. At that…

Nikolay Samokhvalov (@samokhvalov): #PostgresMarathon 2-004: Fast-path locking explained postgr.es/p/7iD

Nikolay Samokhvalov (@samokhvalov): #PostgresMarathon 2-003: The roots of LWLock:LockManager postgr.es/p/7iE

Nikolay Samokhvalov (@samokhvalov): #PostgresMarathon 2-002: Relation-level locks postgr.es/p/7iF

Nikolay Samokhvalov (@samokhvalov): #PostgresMarathon 2-001: Lightweight and heavyweight locks postgr.es/p/7iG

#PostgresMarathon 2-004: Fast-path locks explained (and the PG 18 improvement) 🖖 don't forget to subscribe & share! we'll be diving into various dark corners of Postgres and learn how to make it ludicrously fast 🎇 After 2-003, @ninjouz asked: > If fast-path locks are stored…

#PostgresMarathon 2-003: The roots of LWLock:LockManager As we discussed, Lock Manager manages heavyweight locks – various kinds of them (various modes, various levels of granularity). These locks are released only at the end of the transaction. In the most trivial case, when…

#PostgresMarathon 2-002 // I'm in a very grumpy mood this Sunday evening, so expect me to be rattling about inconsistencies and docs confusion today – perhaps, I blame myself for pulling me to this marathon again, but I won't give up because something does tell me that marathon…

#PostgresMarathon 2-001 To warm up, let's talk about lightweight and heavyweight locks (or "regular locks" or just "locks"). I'm using these materials: - PG docs (first of all, postgresql.org/docs/current/e…) - LockManager source code – src/backend/storage/lmgr (and first of all,…

#PostgresMarathon 2-002 // I'm in a very grumpy mood this Sunday evening, so expect me to be rattling about inconsistencies and docs confusion today – perhaps, I blame myself for pulling me to this marathon again, but I won't give up because something does tell me that marathon…

#PostgresMarathon day 81: How to plot graphs right in psql on macOS (iTerm2) If you, like me, work with Postgres mostly in psql, you might want to be able to plot a simple graph not leaving psql. The recipe below was originally described by Alexander Korotkov…

#PostgresMarathon 2-004: Fast-path locks explained (and the PG 18 improvement) 🖖 don't forget to subscribe & share! we'll be diving into various dark corners of Postgres and learn how to make it ludicrously fast 🎇 After 2-003, @ninjouz asked: > If fast-path locks are stored…

(is this useful? continue?) #PostgresMarathon 093 # How to troubleshoot streaming replication lag Streaming replication in Postgres allows for continuous data replication from a primary server to standby servers, to ensure high availability and balance read-only workloads.…

#PostgresMarathon day 67: Autovacuum "queue" and progress We know that in some cases, autovacuum settings (especially if they are default) need to be adjusted to keep up with the updates. One of the ways to understand that the existing settings are "not enough" is to compare…

📈 #PostgresMarathon tweets have impressed people 1M times already

#PostgresMarathon day 73: How to analyze heavyweight locks, part 3. Persistent monitoring If a spike of active sessions ("pg_stat_activity", state='active') occurs along with a spike of exclusive locks ("pg_locks", mode ~* 'exclusive'), we need to analyze the blocked and…

#PostgresMarathon day 91: How to format text output in psql scripts // catching up; happy holidays! For psql's "\echo" command, using colors and basic text formatting such as bold or underlined can be done through the use of ANSI color codes. This can be useful when building…

#PostgresMarathon day 82: How to draw frost patterns using SQL ❄️ This original idea and implementation was done by Kirill Borovikov (kilor) – I just reformatted and slightly tuned it, extending the character set. Here is the query: with recursive t as ( select 0…

#PostgresMarathon 2-005 More LWLock:LockManager benchmarks for Postgres 18 In 2023-2024, after incidents that multiple customers of PostgresAI experienced, when production nodes were down because of LWLock:LockManager contention, we studied it in synthetic environments. At that…