Re: cluster index on a table

From: Ibrahim Harrani <ibrahim(dot)harrani(at)gmail(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: cluster index on a table
Date: 2009-07-15 15:04:23
Message-ID: 530068a0907150804p7455348fp4ec264448b9c36bf@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(dot)marlowe(at)gmail(dot)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.
>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Marko Kreen 2009-07-15 15:10:30 Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance
Previous Message Tom Lane 2009-07-15 14:59:16 Re: BUG #4919: CREATE USER command slows down system performance