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.