Horton

Re: I: About "Our CLUSTER implementation is pessimal" patch

Simon Riggs <simon@2ndquadrant.com>

View thread
From: Simon Riggs <simon@2ndQuadrant.com>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Itagaki Takahiro <itagaki.takahiro@gmail.com>, Josh Kupershmidt <schmiddy@gmail.com>, Leonardo Francalanci <m_lists@yahoo.it>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2010-09-30T18:02:01Z
Lists: pgsql-hackers 
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.

-- 
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Development, 24x7 Support, Training and Services