I have some simple joins that are taking FOREVER to run - on a couple tables with only maybe a hundred thousand rows. I've done vacuum analyze on the tables but they still seem to take a lot of time. Where should I go first for optimizing my postgres server to handle this better? Are there memory options to increase a buffer in postgres, or are there specific ways to optimize the query itself?
Thanks,
Eric