Re: Scrollable cursors and Sort performance - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Scrollable cursors and Sort performance
Date
Msg-id 12945.1139584407@sss.pgh.pa.us
Whole thread Raw
In response to Scrollable cursors and Sort performance  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Scrollable cursors and Sort performance
List pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
> Which shows that the *unnecessary* final merge takes 344 secs, adding
> approximately 60% to the elapsed time of the query and nearly doubling
> the CPU requirement.

The merge step would certainly have to happen anyway, so this claim is
not justified.  You have not presented any evidence about how much of
the reported time is actually I/O related.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Marko Kreen
Date:
Subject: Re: FW: PGBuildfarm member snake Branch HEAD Status changed from OK to ContribCheck failure
Next
From: "Dave Page"
Date:
Subject: Re: FW: PGBuildfarm member snake Branch HEAD Status changed from OK to ContribCheck failure