Re: [PERFORM] Fill Factor

2011-05-17 Thread Cédric Villemain
2011/5/17 Scott Marlowe : > On Tue, May 17, 2011 at 6:59 AM, Anibal David Acosta > 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 >

Re: [PERFORM] Fill Factor

2011-05-17 Thread Scott Marlowe
On Tue, May 17, 2011 at 6:59 AM, Anibal David Acosta 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 table will be ava

[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 tab