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 2532FDB6AF for ; Tue, 1 Nov 2005 13:25:20 -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 85703-06 for ; Tue, 1 Nov 2005 17:25:10 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id 5B376DA9C4 for ; Tue, 1 Nov 2005 13:25:09 -0400 (AST) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 01 Nov 2005 11:25:06 -0600 Subject: Re: Pre-allocate space in advance From: Scott Marlowe To: "Tomeh, Husam" Cc: Tom Lane , pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1130865905.15018.49.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Tue, 01 Nov 2005 11:25:06 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.007 required=5 tests=[AWL=0.006, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.007 X-Spam-Level: X-Archive-Number: 200511/4 X-Sequence-Number: 19377 On Tue, 2005-11-01 at 11:17, Tomeh, Husam wrote: > I don't have any numbers; and it may be an misconception as you pointed > out that's out there among Oracle DBAs that need to be re-visited again. > > Tom, could you also explain what you meant in a previous post I found > during my research on this issue, which I may have misunderstood it: "I > actually wish that Postgres would preallocate a lot of blocks in advance > (ie. 100 x 8KB). That would probably improve performance, as it would > not have to keep re-extending the file." > > http://archives.postgresql.org/pgsql-interfaces/2001-01/msg00153.php > > Thanks, Ummm, that was a different Tom, wasn't it?