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/ -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
