[PERFORM] Fill Factor

2011-05-17 Thread Anibal David Acosta
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

Re: [PERFORM] Fill Factor

2011-05-17 Thread Scott Marlowe
On Tue, May 17, 2011 at 6:59 AM, Anibal David Acosta a...@devshock.com wrote: Hello, How fillfactor impact performance of query? Fillfactor tells the db how much empty space to leave in the database when creating a table and inserting rows. If you set it to 90% then 10% of the space in the

Re: [PERFORM] Fill Factor

2011-05-17 Thread Cédric Villemain
2011/5/17 Scott Marlowe scott.marl...@gmail.com: On Tue, May 17, 2011 at 6:59 AM, Anibal David Acosta a...@devshock.com wrote: Hello, How fillfactor impact performance of query? Fillfactor tells the db how much empty space to leave in the database when creating a table and inserting rows.