Re: Performance on query PHP/POSTGRESQL

On Tue, Nov 28, 2000 at 10:14:31AM +1100, john slee wrote: > 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. woops, forgot to mention... this is intended to be done at the pg commandline... not in php :-) -- .----------+------------------------------------. |John Slee `-----------. <john@chirp.com.au>| |Chirp Web Design | http://www.chirp.com.au| |Phone: +61 2 62301871 `----. +61 2 62301515 Fax| `---------------------------+-------------------'