[PERFORM] Select from sequence in slow query log

2012-06-01 Thread Chris Rimmer
While investigating some performance issues I have been looking at slow queries logged to the postgresql.log file. A strange thing that I have seen is a series of apparently very slow queries that just select from a sequence. It is as if access to a sequence is blocked for many sessions and then

Re: [PERFORM] Select from sequence in slow query log

2012-06-01 Thread Chris Rimmer
operations, I'm not worrying too much about them now. Thanks Chris On 1 June 2012 14:47, Tom Lane t...@sss.pgh.pa.us wrote: Chris Rimmer chr...@we7.com writes: While investigating some performance issues I have been looking at slow queries logged to the postgresql.log file. A strange thing