Re: cluster index on a table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Title: Re: cluster index on a table
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@xxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux