Joel Fradkin wrote:
Here is the result after putting it back to 4 the original value (I had done that prior to your suggestion of using 2 or 3) to see what might change. I also vacummed and thought I saw records deleted in associate, which I found odd as this is a test site and no new records were added or deleted.
Well, that looks 2x as fast, right?
You might try SET enable_mergejoin TO off;
Just to see if you can force a hash-join and see how long that takes. You might also try increasing work_mem. You can do that just in the current session with
SET work_mem TO ....;
Description: OpenPGP digital signature