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?
make explain analyze of original query (notice *explain analyze* and not *explain*), and post this to list. otherwise - you can't really hope someone will tell you what's wrong.
depesz
--
http://www.depesz.com/ - nowy, lepszy depesz