> Are the tables perhaps nearly in order by the dsiacctno fields?
> If that were the case, and the planner were missing it for some reason,
> these results would be plausible.
>
> BTW, what are you using for work_mem, and how does that compare to your
> available RAM?
>
> regards, tom lane
>
My assumption would be they are in exact order. The text file I used
in the COPY statement had them in order, so if COPY preserves that in
the database, then it is in order.
The system has 8GB of ram and work_mem is set to 256MB.
I'll see if I can't make time to run the sort-seqscan method so we can
have an exact time to work with.
