CLUSTER micro-doc-patch - Mailing list pgsql-patches

From Sergey E. Koposov
Subject CLUSTER micro-doc-patch
Date
Msg-id Pine.LNX.4.64.0611041615320.24412@lnfm1.sai.msu.ru
Whole thread Raw
Responses Re: CLUSTER micro-doc-patch  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
Hello All,

Doing recently the CLUSTER operation with (SELECT .. ORDER BY ...) instead
of CLUSTER I realized that that operation requires the free space equal to
twice! the size of the table size :-( (which is unfortunately a serious
drawback of the SELECT method, comparing to the plain CLUSTER for
the large tables )...

So, I send the small doc-patch saying about the space requirement of the
cluster operation using SELECT ORDER BY.

Regards,
     Sergey

*******************************************************************
Sergey E. Koposov
Max Planck Institute for Astronomy/Sternberg Astronomical Institute
Tel: +49-6221-528-349
Web: http://lnfm1.sai.msu.ru/~math
E-mail: math@sai.msu.ru

Attachment

pgsql-patches by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: [HACKERS] Bug in WAL backup documentation
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Bug in WAL backup documentation