Re: Query optimization

Richard Huxton <dev@archonet.com> writes:
> First stage though, run an EXPLAIN and if you need help understanding it post
> the output back to the list.

Yep, that's a good idea. Another thing to try is to disable GEQO (SET
geqo = off;) and see what difference that makes to the performance of
the optimizer and the quality of the chosen plan (12 relations is
close to the cross-over point for the useability of the genetic
optimizer, IME).

Also, your comment regarding slow access over the Internet is not a
problem with PostgreSQL -- if it really *is* 2x or so slower when done
remotely, talk to your network admin.

Cheers,

Neil

--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC