Обсуждение: pgsql: Add note about space usage of 'manual' approach to clustering,

Поиск
Список
Период
Сортировка

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

От
tgl@postgresql.org (Tom Lane)
Дата:
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)

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

От
"Simon Riggs"
Дата:
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