Re: Performance on query PHP/POSTGRESQL

On Mon, Nov 27, 2000 at 01:39:21PM -0700, Mark Newnham wrote: > (postgres newbie question) [ ... long query stuff ] > The query takes 5 or 6 minutes to run. It's almost as if I am not using an > index for the second query. Can anyone point me to a problem in my query? you can look for these problems yourself - its as easy as putting the word "explain" before your query. pg will tell you which bits of the query are the most expensive, and why... comparing your 5 second query to the 5 minute query with 'explain' should be helpful. j. -- .----------+------------------------------------. |John Slee `-----------. <john@chirp.com.au>| |Chirp Web Design | http://www.chirp.com.au| |Phone: +61 2 62301871 `----. +61 2 62301515 Fax| `---------------------------+-------------------'