"Jignesh K. Shah" <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> So follow that up --- try to determine which lock is being contended >> for. There's some very crude code in the sources that you can enable >> with -DLWLOCK_STATS, but probably DTrace would be a better tool.
> Using plockstat -A -s 5 -p $pid I don't know what that is, but it doesn't appear to have anything to do with Postgres LWLocks or spinlocks, which are the locks I was thinking of. Try asking Robert Lor about this --- IIRC he had some dtrace probes to work with our locks. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org