| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Scrollable cursors and Sort performance |
| Date: | 2006-02-10 15:13:27 |
| Message-ID: | 12945.1139584407@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Simon Riggs <simon(at)2ndquadrant(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2006-02-10 15:14:13 | Re: FW: PGBuildfarm member snake Branch HEAD Status changed from OK to ContribCheck failure |
| Previous Message | Marko Kreen | 2006-02-10 15:11:24 | Re: FW: PGBuildfarm member snake Branch HEAD Status changed from OK to ContribCheck failure |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2006-02-10 15:14:13 | Re: FW: PGBuildfarm member snake Branch HEAD Status changed from OK to ContribCheck failure |
| Previous Message | Tom Lane | 2006-02-10 15:01:36 | Re: ignore_killed_tuples is always true |