Re: insane index scan times

On 6/8/07, Martijn van Oosterhout <kleptog(at)svana(dot)org> wrote:
> On Thu, Jun 07, 2007 at 11:20:20AM -0700, Sergei Shelukhin wrote:
> > Version is 8.1
> > The query I originally ran returned ~4-5 rows and had a lot of other
> > joins and filtering conditions prior to the join with the big table.
> > Is there any way to instruct postgres to do joins in the specific
> > order or smth?
>
> Not really, Postgres can rearrange joins into the order it works out to
> be the best.

Are you sure? I was under the impression that PostgreSQL could reorder
"where" clauses, but did not yet reorder explicit joins (as opposed
to implicit ones through, say, "in"). But perhaps it only applied to
some types of joins.

Alexander.