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, 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
