"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
