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 ....;
John
=:->