Michael Monnerie wrote: > 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. Right -- I'm just saying that if you cluster a table, you don't need to vacuum it. Of course, you need to vacuum all the other tables. > Also, I think pg_toast tables cannot be clustered, right? Not directly, but if you cluster a plain table, its toast table is clustered too. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
