It looks like this effect only occurs in the middle of the night when there
is some kind of automated dump process going on and the system is under
higher than normal load. I haven't managed to reproduce them outside of
production, but since these oddities don't seem to show up during normal
operat
Chris Rimmer writes:
> 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 blocke
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
