Hi Tom,
> I doubt we'd risk destabilizing 8.3 at this point, for a problem that
> affects so few people; let alone back-patching into 8.2.
understand.
> OK, that confirms the theory that it's sinval-queue contention.
We'we tried hard to identify what's the cause of filling sinval-queue.
We went through query logs as well as function bodies stored in the
database. We were not able to find any DDL, temp table creations etc.
We did following experiment: stop one of our clients, so there started
to be queue of events (aka rows in db) for it to process. Then we
started the client again, it started processing the queue - that means
calling simple selects, updates and complex plpgsql function(s). And at
this moment, the spike started even it shouldn't start to meet usual
periodicity. It's consistent. We are pretty sure that this client is not
doing any DDL...
What should we look for to find the cause?
Thanks for any hints,
Kuba