1. Have you checked whether all fields which you are joining are indexed.
2. Are you sure that your query is not have any subselects, if it have any
subselects convert into joins.
3.Check what is the size of tables. If tables size is very big do filter
condtions
4. Even if you feel that your query is still working slow, then denormalise
your database and avoid atleast some joins.
Regards,
Sreedhar
----- Original Message -----
From: "Abdul-wahid Paterson" <aw(at)lintrix(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Saturday, March 15, 2003 6:39 AM
Subject: [GENERAL] query optimisation