Simon Riggs <simon@2ndquadrant.com> writes:
> The main problem on INSERTs is that it is usually the same few pages:
> the lead data block and the lead index block. There are ways of
> spreading the load out across an index, but I'm not sure what happens on
> the leading edge of the data relation, but I think it hits the same
> block each time.
FSM does what it can to spread the insertion load across multiple pages,
but of course this is not going to help much unless your table has lots
of embedded free space. I think it would work pretty well on a table
with lots of update turnover, but not on an INSERT-only workload.
regards, tom lane