Re: avoiding seqscan? - Mailing list pgsql-performance

From Gaetano Mendola
Subject Re: avoiding seqscan?
Date
Msg-id 3F78346F.5060809@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 use the explicit join will be less
limitative for the planner.

Regards
Gaetano Mendola


pgsql-performance by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: advice on raid controller
Next
From: Oleg Lebedev
Date:
Subject: Re: TPC-R benchmarks