Skip site navigation (1) Skip section navigation (2)

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 (view raw)
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: cluster-doc.patch
Description: text/plain (1.5 KB)
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)postgresql(dot)org, "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: CLUSTER micro-doc-patch
Date: 2006-11-04 19:04:26
Message-ID: 25047.1162667066@sss.pgh.pa.us (view raw)
"Sergey E. Koposov" <math(at)sai(dot)msu(dot)ru> writes:
> So, I send the small doc-patch saying about the space requirement of the 
> cluster operation using SELECT ORDER BY.

Added, along with some other minor editorial fixes.

			regards, tom lane


Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group