On 9/26/07, James Williams <james.wlms@xxxxxxxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
