Replica vs standby

2023-09-05 Thread Bruce Momjian
I started digging into this and came up with a can of worms. I have therefore updated the email subject. Our glossary has: https://www.postgresql.org/docs/devel/glossary.html --> Standby (server) See Replica (server). --> Replica (server)

Clarification of deadlock possibilities in section 13.3.5. Advisory Locks

2023-09-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/explicit-locking.html Description: Hi, An example from section 13.3.5. Advisory Locks (I included the ORDER BY for deterministic results): SELECT pg_advisory_lock(q.id) FROM ( SELECT id