Postgres 7.1.3 a clustrovane indexy
Karel Zak
zakkr na zf.jcu.cz
Středa Listopad 28 10:21:32 CET 2001
On Tue, Nov 27, 2001 at 01:11:52PM +0100, Otakar Kleps wrote:
> Dobry den.
>
> Mam dotaz ohledne pouzivani clustrovaneho indexu v praxi.
> 1) Jakym zpusobem probiha clustrovani na urovni Linux/Postgres. Jde mi
> konkretne v pouziti INSERT/DELETE/UPDATE.
To popisuje dokumentace:
When a table is clustered, it is physically reordered based on the index
information. The clustering is static. In other words, as the table is
updated, the changes are not clustered. No attempt is made to keep new
instances or updated tuples clustered. If one wishes, one can re-cluster
manually by issuing the command again.
Karel
--
Karel Zak <zakkr na zf.jcu.cz>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
Další informace o konferenci Test