CLUSTER micro-doc-patch

From: "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru>
To: pgsql-patches(at)postgresql(dot)org
Subject: CLUSTER micro-doc-patch
Date: 2006-11-04 13:41:43
Message-ID: Pine.LNX.4.64.0611041615320.24412@lnfm1.sai.msu.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers 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(at)sai(dot)msu(dot)ru

Attachment Content-Type Size
cluster-doc.patch text/plain 1.5 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-11-04 17:35:16 Proposal: vacuum and autovacuum parameters to control freezing
Previous Message Magnus Hagander 2006-11-03 23:43:33 Re: [HACKERS] Bug in WAL backup documentation

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2006-11-04 17:35:16 Proposal: vacuum and autovacuum parameters to control freezing
Previous Message Magnus Hagander 2006-11-03 23:43:33 Re: [HACKERS] Bug in WAL backup documentation