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@xxxxxxxxxxxxxxxxx> 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@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 > > -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
