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

From Scott Carey
Subject Re: Database size growing over time and leads to performance impact
Date
Msg-id 1C31A98A-7789-452F-844C-D52ECD27D788@richrelevance.com
Whole thread Raw
In response to Re: Database size growing over time and leads to performance impact  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On Apr 1, 2010, at 1:42 PM, Tom Lane wrote:

> Scott Carey <scott@richrelevance.com> writes:
>> Still off topic:
>
>> Will CLUSTER/VF respect FILLFACTOR in 9.0?
>
>> As far as I can tell in 8.4, it does not.
>
> Works for me, in both branches.
>

I stand corrected.  I must have done something wrong in my test.  On a different system I tried FILLFACTOR=45 and
FILLFACTOR=90and the resulting size was nearly a factor of two different. 

>             regards, tom lane


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Database size growing over time and leads to performance impact
Next
From: Christiaan Willemsen
Date:
Subject: Using high speed swap to improve performance?