On Wed, Mar 31, 2010 at 4:37 PM, Scott Carey <scott@xxxxxxxxxxxxxxxxx> wrote: > On Mar 27, 2010, at 6:35 AM, Andy Colson wrote: >> >> Dont "VACUUM FULL", its not helping you, and is being removed in newer versions. >> > > Off topic: How is that going to work? CLUSTER doesn't work on tables without an index. I would love to be able to CLUSTER on some column set that doesn't necessarily have an index. I believe the new VF implementation just rewrites the data in the same physical order as it was in previously, but without the dead space. So it's sort of like cluster-by-no-index-at-all. ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
