Robert James wrote:
> Thanks for the replies. I'm running Postgres 8.2 on Windows XP, Intel
> Core Duo (though Postgres seems to use only one 1 core).
A single query can only use one core, but it will use both if multiple
queries come in.
> The queries are self joins on very large tables, with lots of nested loops.
If you want help optimizing them, you'll need to send through
- explain analyze
- table definitions
and of course
- the query itself
--
Postgresql & php tutorials
http://www.designmagick.com/