I'd love to see it. On Wed, Jul 15, 2009 at 8:17 PM, Justin Pitts<justinpitts@xxxxxxxxx> wrote: > Is there any interest in adding that (continual/automatic cluster > order maintenance) to a future release? > > On Wed, Jul 15, 2009 at 8:33 PM, 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 >> >> > -- When fascism comes to America, it will be intolerance sold as diversity. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
