| 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: | Whole Thread | Raw Message | 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 |
| 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 |
| 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 |