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" <[email protected]> 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<[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
