On Wed, Mar 31, 2010 at 4:37 PM, Scott Carey <sc...@richrelevance.com> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
