Thread: fillfactor Question

fillfactor Question

From
Siah
Date:
Hi,

fillfactor affects 'update' statements or also has affects for
'insert' and 'delete'?

Thanks,
Sia


Re: fillfactor Question

From
"Albe Laurenz"
Date:
Siah wrote:
> fillfactor affects 'update' statements or also has affects for
> 'insert' and 'delete'?

I would say: fillfactor modifies the behaviour of INSERT and
has effects for UPDATE.

When you choose fillfactor less than the default 100, INSERT
will not fill the pages completely. This will slow down insert a
little (if fillfactor is 90, then roughly 10% more pages will
be written because each is only 90% full, leading to more I/O).

On the other hand, it will speed up an UPDATE considerably, because
if there is still enough space in the block, the UPDATE will
only have to touch one data block instead of two.

The speed of DELETE should not be affected.

Yours,
Laurenz Albe