Scott Marlowe <smarlowe@xxxxxxxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
