Re: Database size growing over time and leads to performance impact - Mailing list pgsql-performance

From Robert Haas
Subject Re: Database size growing over time and leads to performance impact
Date
Msg-id t2k603c8f071003311347re104c292v9a052e493c540e14@mail.gmail.com
Whole thread Raw
In response to Re: Database size growing over time and leads to performance impact  (Scott Carey <scott@richrelevance.com>)
Responses Re: Database size growing over time and leads to performance impact  (Scott Carey <scott@richrelevance.com>)
List pgsql-performance
On Wed, Mar 31, 2010 at 4:37 PM, Scott Carey <scott@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
CLUSTERon 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

pgsql-performance by date:

Previous
From: Scott Carey
Date:
Subject: Re: Database size growing over time and leads to performance impact
Next
From: Alvaro Herrera
Date:
Subject: Re: Database size growing over time and leads to performance impact