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 i
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 wrote:
>
> Yeah: absolute first
Hello,
I am seeing some strange performance on a new pg9.1 instance. We are seeing
occasional statement timeouts on some TRUNCATEs and INSERTs. In both cases,
the statements are quite simple:
- TRUNCATE schema.table;
- INSERT INTO schema.table VALUES ($1,2,$2,'');
Sometimes these will
