On Feb 12, 2008 4:11 AM, Thomas Zaksek <zaksek@xxxxxxxxxxxxxx> wrote:
> I tried turning off nestloop, but with terrible results:
Yeah, it didn't help. I was expecting the query planner to switch to
a more efficient join plan.
> I also tried to increase work_men, now the config is
> work_mem = 4MB
Try setting it higher for JUST THIS query. i.e.
set work_mem=128M;
explain analyze select ....
and see how that runs. Then play with it til you've got it down to
what helps. Note that work_mem in postgresql.conf being too large can
be dangerous, so it might be something you set for just this query for
safety reasons.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
