I have two tables that represent a one-to-many relationship in our database. One table is relatively small (~2000 rows) and the other is relatively large (~65M rows). When I try to join these tables, Postgres does a sequential scan an the large table. This, combined with the append and hash join is taking about 3 minutes to complete.
I'm guessing that I am doing something wrong in my query to make it take so long. Is there a good reference somewhere on how to do joins intelligently?
Matt