Scott Marlowe <smarlowe@g2switchworks.com> writes:
> On Mon, 2005-10-31 at 16:34, Tomeh, Husam wrote:
>> Pre-allocating space will prevent extending the datafile during
>> loading massive data (batch processing) and would improve the overall
>> batch write performance.
> Have you got any file system benchmarks that back up this assertion? I
> would love to see something that shows one way or the other if that
> really makes any difference.
Barring some pretty solid evidence, you're unlikely to attract any
enthusiasm among pghackers for this sort of thing. We are generally
disinclined to reinvent functionality that properly belongs to the
kernel or filesystem layer. "Oracle does it" cuts no ice in this
connection, because Oracle is designed around a twenty-year-old
assumption that the database is smarter than the kernel, and the world
has changed a lot since then.
In short: show us some numbers that prove this is worth our attention.
regards, tom lane