On Freitag 19 Dezember 2008 Alvaro Herrera wrote: > You don't need to vacuum or reindex after a cluster; it removes all > dead rows (except those that vacuum won't remove anyway) OK, but I do not cluster all tables, as it only makes sense for tables which get read in some sequential (based on that index) way. For completely random accessed tables I skip cluster, and rely on vacuum/reindex. Also, I think pg_toast tables cannot be clustered, right? mfg zmi -- // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4
Attachment:
signature.asc
Description: This is a digitally signed message part.
