Re: Fillfactor in postgresql 9.2 - Mailing list pgsql-performance

From Albe Laurenz
Subject Re: Fillfactor in postgresql 9.2
Date
Msg-id A737B7A37273E048B164557ADEF4A58B17BC3F9B@ntex2010a.host.magwien.gv.at
Whole thread Raw
In response to Fillfactor in postgresql 9.2  (Niels Kristian Schjødt <nielskristian@autouncle.com>)
Responses Re: Fillfactor in postgresql 9.2  (Pavan Deolasee <pavan.deolasee@gmail.com>)
List pgsql-performance
Niels Kristian Schjødt wrote:
> I am experiencing a similar issue as the one mentioned in this post
> http://stackoverflow.com/questions/3100072/postgresql-slow-on-a-large-table-with-arrays-and-lots-of-
> updates/3100232#3100232
> However the post is written for a 8.3 installation, so I'm wondering if the fillfactor problem is
> still roughly the same in 9.2, and hence would have a similar effect when adjusted?

Yes, lowering the fillfactor for a table will still
increase the chances of HOT updates, improving performance
and reducing the need for maintenance.

Yours,
Laurenz Albe

pgsql-performance by date:

Previous
From: Niels Kristian Schjødt
Date:
Subject: Fillfactor in postgresql 9.2
Next
From: Pavan Deolasee
Date:
Subject: Re: Fillfactor in postgresql 9.2