Re: Multiple sorts in a query - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Multiple sorts in a query
Date
Msg-id A893882B-C8CB-4B98-A5BD-B516F9F14409@enterprisedb.com
Whole thread Raw
In response to Re: Multiple sorts in a query  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Multiple sorts in a query  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Well I'm just saying if you realloc a x kilobyte block into a 2x block  
and the allocator can't expand it and has to copy then it seems  
inevitable.

-- 
Greg


On 19 May 2009, at 14:11, Simon Riggs <simon@2ndQuadrant.com> wrote:

>
> On Tue, 2009-05-19 at 13:52 +0100, Greg Stark wrote:
>
>> So at least transiently we use 3x the size of the actual array.
>
> I was conjecturing, prior to investigation. Are you saying you know
> this/have seen this already?
>
> -- 
> Simon Riggs           www.2ndQuadrant.com
> PostgreSQL Training, Services and Support
>


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Multiple sorts in a query
Next
From: Adriano Lange
Date:
Subject: Re: GEQO: ERX