Re: SORT performance - slow?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"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


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux