Fill Factor

From: "Anibal David Acosta" <aa(at)devshock(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Fill Factor
Date: 2011-05-17 12:59:50
Message-ID: 003201cc1492$514419a0$f3cc4ce0$@devshock.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello,

How fillfactor impact performance of query?

I have two cases,
One is a operational table, for each insert it have an update, this table
must have aprox. 1.000 insert per second and 1.000 update per second (same
inserted row)
Is necessary to change the fill factor?

The other case is a table that have few insert (statistics) but thousands or
millons of update, In this case the fillfactor is not necessary to change?

Thanks!

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2011-05-17 13:23:41 Re: Fill Factor
Previous Message Andrey Vorobiev 2011-05-17 12:45:32 Performance degradation of inserts when database size grows