Postgres 7.1.3 a clustrovane indexy

Karel Zak zakkr na
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 Zak  <zakkr na>
 C, PostgreSQL, PHP, WWW,,

Další informace o konferenci Test