"Jason Coene" <jcoene(at)gotfrag(dot)com> writes:
> All of our "postgres" processes end up in the "semwai" state - seemingly
> waiting on other queries to complete. If the system isn't taxed in CPU or
> disk, I have a good feeling that this may be the cause.
Whatever that is, I'll bet lunch that it's got 0 to do with caching
query plans. Can you get stack tracebacks from some of the stuck
processes? What do they show in "ps"?
regards, tom lane