Postgres Pro
Downloads
Home   >   mailing lists

Re: Query optimization / automatic re-ordering of tables - Mailing list pgsql-novice

From Tom Lane
Subject Re: Query optimization / automatic re-ordering of tables
Date
Msg-id 25988.1153320564@sss.pgh.pa.us
Whole thread Raw
In response to Query optimization / automatic re-ordering of tables  ("Verena Ruff" <lists@triosolutions.at>)
Responses Re: Query optimization / automatic re-ordering of tables
List pgsql-novice
Tree view 
"Verena Ruff" <lists@triosolutions.at> writes:
> The WHERE clause is created dynamically and may contain fields of each
> table which is part of the join, so I can't just change the order of the
> tables in my code to get the best result. Is there a way to make those
> optimizations (re-ordering of tables) automatically?

CVS HEAD (PG 8.2 to be) is reasonably bright about re-ordering left
joins, but no current release tries to do it at all...

            regards, tom lane

pgsql-novice by date:

Previous
From: "Glenn"
Date:
Subject: wild cards in pg_hba.conf
Next
From: Tom Lane
Date:
Subject: Re: case-insensitive Index