Michael van Rooyen <michael@xxxxxxxxxx> writes: > On 2014/04/28 07:50 PM, Tom Lane wrote: >> Hm ... it seems pretty suspicious that all of these examples take just >> about exactly 1 second longer than you might expect. I'm wondering >> if there is something sitting on an exclusive table lock somewhere, >> and releasing it after 1 second. > I do have log_min_duration_statement = 1000, which may cause this. Ah, I overlooked that detail. Never mind that theory then. Although it might still be worth turning on log_lock_waits for awhile, just to eliminate the possibility of lock-induced delays. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
