Re: I: About "Our CLUSTER implementation is pessimal" patch - Mailing list pgsql-hackers

From Tom Lane
Subject Re: I: About "Our CLUSTER implementation is pessimal" patch
Date
Msg-id 11091.1285873469@sss.pgh.pa.us
Whole thread Raw
In response to Re: I: About "Our CLUSTER implementation is pessimal" patch  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: I: About "Our CLUSTER implementation is pessimal" patch  (Itagaki Takahiro <itagaki.takahiro@gmail.com>)
List pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> writes:
> On Wed, 2010-09-29 at 08:44 -0400, Alvaro Herrera wrote:
> So, I think "twice disk space of the sum of table and indexes" would be
> the simplest explanation for safe margin.
>> 
>> Agreed.

> Surely the peak space is x3?
> Old space + sort space + new space.

The wording should be something like "CLUSTER requires transient disk
space equal to about twice the size of the table plus its indexes".
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: security hook on table creation
Next
From: Robert Haas
Date:
Subject: O_DSYNC broken on MacOS X?