Postgres Pro
Downloads
Home   >   mailing lists

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

From Ibrahim Harrani
Subject Re: cluster index on a table
Date
Msg-id 530068a0907150804p7455348fp4ec264448b9c36bf@mail.gmail.com
Whole thread Raw
In response to Re: cluster index on a table  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: cluster index on a table  (Scott Carey <scott@richrelevance.com>)
List pgsql-performance
Tree view 
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.
>

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #4919: CREATE USER command slows down system performance
Next
From: Marko Kreen
Date:
Subject: Re: [BUGS] BUG #4919: CREATE USER command slows down system performance