Re: performance issue

AFAICT this is exactly the type of output explain or explain analyze
will tell you. Please go back and reread the docs on these commands and
if you don't understand how to interpret the info post back and we'll
try to help more.

Robert Treat

On Mon, 2002-10-28 at 03:10, Savita wrote:
> Hi,
>
> I was looking for something like this.
>
> InMssql when I use a query like selece a,b from some table where
> a.x=b.y,then if a is having say 30000 records and b is having 4 records then
> it will compare all the 30000 records with the 4 records one by one,but if I
> make it where b.y=a.x then it will be faster.
>
> I know with index I could increase the performance by 50 %,but what other
> possibilities are there to improve the performance
>
> Stephan Szabo wrote:
>
> > On Mon, 28 Oct 2002, Savita wrote:
> >
> > > Using explain I am not able to get the detailed information.
> >
> > What information are you looking to get?
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> > message can get through to the mailing list cleanly
>
> --
> Best Regards
> - Savita
> ----------------------------------------------------
> Hewlett Packard (India)
> +91 80 2051288 (Phone)
> 847 1288 (HP Telnet)
> ----------------------------------------------------
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster