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
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
In response to
pgsql-general by date
|Next:||From: Oleg Bartunov||Date: 2007-09-26 19:41:44|
|Subject: Re: DAGs and recursive queries|
|Previous:||From: Gowrishankar||Date: 2007-09-26 18:58:38|
|Subject: Data cube in PostgreSQL|