CLUSTER micro-doc-patch

Started by Sergey E. Koposovover 19 years ago2 messageshackers
Jump to latest
#1Sergey E. Koposov
math@sai.msu.ru

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

Attachments:

cluster-doc.patchtext/plain; charset=US-ASCII; name=cluster-doc.patchDownload+5-5
#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Sergey E. Koposov (#1)
Re: CLUSTER micro-doc-patch

"Sergey E. Koposov" <math@sai.msu.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