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

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

[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 r