Re: Getting rid of excess lseeks()

Mike Mascari <mascarm(at)mascari(dot)com> writes:
> If your idea works, would it be possible, or even a good idea, to
> have PostgreSQL extend the relation in a non-linear fashion?

The trick would be to ensure that the extra blocks actually got used
for something ... without more logic than is there now, all the backends
would glom onto the last new page and ignore the possibility of putting
tuples into the other pages you'd added.

The hack I've proposed (and am currently testing) doesn't really do
anything to reduce the per-page overhead of extending the relation.
What it does do is reduce the per-tuple overhead of adding tuples
to an extant last page. Basically we are down to an lseek per block
instead of an lseek per tuple ...

regards, tom lane