Mike Mascari <[EMAIL PROTECTED]> 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,
We've known for a long time that Postgres does a lot of
redundant-seeming "lseek(fd,0,SEEK_END)" kernel calls while inserting
data; one for each inserted tuple, in fact. This is coming from
RelationGetBufferForTuple() in src/backend/access/heap/hio.c, which does
RelationGetNumberOfBlocks() to ens
