Re: Multiple sorts in a query

From: Greg Stark <greg(dot)stark(at)enterprisedb(dot)com>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>
Cc: Greg Stark <stark(at)enterprisedb(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Multiple sorts in a query
Date: 2009-05-19 20:49:53
Message-ID: A893882B-C8CB-4B98-A5BD-B516F9F14409@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)2ndQuadrant(dot)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
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Adriano Lange 2009-05-19 21:38:04 Re: GEQO: ERX
Previous Message Zdenek Kotala 2009-05-19 20:19:54 Re: Multiple sorts in a query