Обсуждение: fillfactor Question

Hi,

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

Thanks,
Sia

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