[PERFORM] Occasional timeouts on TRUNCATE and simple INSERTs

[Osborn, Jeff]

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 succeed.  Occasionally I see timeouts.  The 
statement_timeout is set to 60 seconds.  These tables are not particularly 
large; in the case of the insert, the table only has three rows.  

Our previous Postgresql 8.2 instance did not have this problem.  Any ideas 
about how to track down the issue?  

Thanks,

--Jeff O

smime.p7s
Description: S/MIME cryptographic signature