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 ....;


Attachment: signature.asc
Description: OpenPGP digital signature

Reply via email to