X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E722BDB600 for ; Mon, 31 Oct 2005 23:59:17 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 00440-07 for ; Tue, 1 Nov 2005 03:59:17 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 988B1DB5FE for ; Mon, 31 Oct 2005 23:59:16 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id jA13xD4g021439; Mon, 31 Oct 2005 22:59:13 -0500 (EST) To: Scott Marlowe Cc: "Tomeh, Husam" , pgsql-admin@postgresql.org Subject: Re: Vacuum Verbose output In-reply-to: <1130799160.15018.35.camel@state.g2switchworks.com> References: <1130799160.15018.35.camel@state.g2switchworks.com> Comments: In-reply-to Scott Marlowe message dated "Mon, 31 Oct 2005 16:52:40 -0600" Date: Mon, 31 Oct 2005 22:59:13 -0500 Message-ID: <21438.1130817553@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.006 required=5 tests=[AWL=0.006] X-Spam-Score: 0.006 X-Spam-Level: X-Archive-Number: 200510/301 X-Sequence-Number: 19373 Scott Marlowe 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