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.
You need to check whether the statistics on your columns are good, so
postgres can make a good estimate.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.