Re: avoiding seqscan? - Mailing list pgsql-performance

From Gaetano Mendola
Subject Re: avoiding seqscan?
Date
Msg-id 3F783433.8000006@bigfoot.com
Whole thread Raw
In response to Re: avoiding seqscan?  (Palle Girgensohn <girgen@pingpong.net>)
List pgsql-performance
Palle Girgensohn wrote:
> Will that make a difference? From what I've seen, it does not make much
> difference, but I have seen queries speed up when rewritten explicit
> joins. I guess it depends on other things, but is it really so that the
> explicit joins are bad somehow? Do you have any pointers to
> documentation about it, if so?
>
> Thanks,
> Palle


Are not absolutelly bad but sometimes that path that you choose is not
the optimal, in postgres 7.4 the think will be better.

Regards
Gaetano Mendola


pgsql-performance by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: avoiding seqscan?
Next
From: Andrew Rawnsley
Date:
Subject: Re: Performance: BigInt vs Decimal(19,0)