"Jignesh K. Shah" <[EMAIL PROTECTED]> writes: > Yes I did see increase in context switches and CPU migrations at that > point using mpstat.
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. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq