Re: SORT performance - slow? - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: SORT performance - slow?
Date
Msg-id 4DD59F1A020000250003D9B1@gw.wicourts.gov
Whole thread Raw
In response to SORT performance - slow?  ("Strange, John W" <john.w.strange@jpmchase.com>)
Responses [OT]: Confidentiality disclosures in list posts (Was: SORT performance - slow?)
List pgsql-performance
"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



pgsql-performance by date:

Previous
From: Cédric Villemain
Date:
Subject: Re: reducing random_page_cost from 4 to 2 to force index scan
Next
From: Dave Johansen
Date:
Subject: Pushing LIMIT into sub-queries of a UNION ALL