Re: Fillfactor in postgresql 9.2

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: Niels Kristian Schjødt *EXTERN* <nielskristian(at)autouncle(dot)com>, "pgsql-performance(at)postgresql(dot)org list" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Fillfactor in postgresql 9.2
Date: 2013-07-02 11:45:03
Message-ID: A737B7A37273E048B164557ADEF4A58B17BC3F9B@ntex2010a.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Pavan Deolasee 2013-07-02 12:09:55 Re: Fillfactor in postgresql 9.2
Previous Message Niels Kristian Schjødt 2013-07-02 11:27:43 Fillfactor in postgresql 9.2