Re: Occasional timeouts on TRUNCATE and simple INSERTs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



You all were right.  The time-outs for TRUNCATE were due to a rogue pg_dump.  And the issue with the inserts was due to an unrelated code change.  

Thanks for your help!

--Jeff O

On Dec 11, 2012, at 5:34 PM, Osborn, Jeff wrote:

> Yeah I've been running a cron pulling relevant info from pg_stat_activity.  Haven't seen anything yet.  Currently looking into the pg_dump situation.
> 
> --Jeff O
> 
> On Dec 11, 2012, at 5:16 PM, Merlin Moncure wrote:
> 
>> On Tue, Dec 11, 2012 at 3:38 PM, Sergey Konoplev <gray.ru@xxxxxxxxx> wrote:
>> 
>> Yeah: absolute first thing to check is if your statements are being
>> blocked -- you can get that via pg_stat_activity from another session.
>> It's a completely different beast if that's the case.
>> 
>> merlin
> 

Attachment: smime.p7s
Description: S/MIME cryptographic signature


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux