pgsql: Add note about space usage of 'manual' approach to clustering,

Started by Tom Laneover 19 years ago2 messagescomitters
Jump to latest
#1Tom Lane
tgl@sss.pgh.pa.us

Log Message:
-----------
Add note about space usage of 'manual' approach to clustering, per
suggestion from Sergey Koposov. Also some other minor editing.

Modified Files:
--------------
pgsql/doc/src/sgml/ref:
cluster.sgml (r1.37 -> r1.38)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/cluster.sgml.diff?r1=1.37&r2=1.38)

#2Simon Riggs
simon@2ndQuadrant.com
In reply to: Tom Lane (#1)
Re: pgsql: Add note about space usage of 'manual'approach to clustering,

On Sat, 2006-11-04 at 15:03 -0400, Tom Lane wrote:

Log Message:
-----------
Add note about space usage of 'manual' approach to clustering, per
suggestion from Sergey Koposov. Also some other minor editing.

With regard to the space usage, I think we should mention that the space
utilised is twice the size of the table on its tablespace, plus a temp
sort file of the same size as the table. Space itself may not be an
issue, but having space in exactly the right place might be.

--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com