On 9/26/07, James Williams <james(dot)wlms(at)googlemail(dot)com> wrote:
> The last is based mostly on the observation that another tiddly
> unrelated mysql db which normally runs fast, grinds to a halt when
> we're querying the postgres db (and cpu, memory appear to have spare
> capacity).
Just a quick observation here.
When the drives are thrashing, is it straight db-storage thrashing, or
is the system swapping out a lot?
Run vmstat 10 while running this query when this happens and pay
attentino to bi bo and si so