Re: cluster index on a table - Mailing list pgsql-performance

From Ibrahim Harrani
Subject Re: cluster index on a table
Date
Msg-id 530068a0907161416v3d4f075y397298285da9ae8b@mail.gmail.com
Whole thread Raw
In response to Re: cluster index on a table  (Scott Carey <scott@richrelevance.com>)
List pgsql-performance
Hi Scott,

Which fillfactor is better 70, 80 or another value?

Thanks.

Thanks

On Thu, Jul 16, 2009 at 3:33 AM, Scott Carey<scott@richrelevance.com> wrote:
> If you have a lot of insert/update/delete activity on a table fillfactor can
> help.
>
> I don’t believe that postgres will try and maintain the table in the cluster
> order however.
>
>
> On 7/15/09 8:04 AM, "Ibrahim Harrani" <ibrahim.harrani@gmail.com> wrote:
>
> Hi,
>
> thanks for your suggestion.
> Is there any benefit of setting fillfactor to 70 or 80 on this table?
>
>
>
> On Wed, Jun 24, 2009 at 8:42 PM, Scott Marlowe<scott.marlowe@gmail.com>
> wrote:
>> As another poster pointed out, you cluster on ONE index and one index
>> only.  However, you can cluster on a multi-column index.
>>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
>

pgsql-performance by date:

Previous
From: Greg Stark
Date:
Subject: Re: cluster index on a table
Next
From: "Kevin Grittner"
Date:
Subject: Re: Very big insert/join performance problem (bacula)