"Strange, John W" wrote: > Am I reading this right in that the sort is taking almost 8 > seconds? > -> Sort ... actual time=14186.977..14287.068 > -> Hash Join ... actual time=6000.728..12037.492 The run time of the sort is the difference between 12037 ms and 14287 ms (the completion times). That's 2.25 seconds. > If you are not the intended recipient, you are hereby notified > that any disclosure, copying, distribution, or use of the > information contained herein (including any reliance thereon) is > STRICTLY PROHIBITED. You probably already know this, but just to make sure -- you posted this to a public list which is automatically replicated to several websites freely available to everyone on the planet. -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance