Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id D09A1133655C for ; Fri, 19 Nov 2010 09:01:53 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 66090-01 for ; Fri, 19 Nov 2010 13:01:46 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mx01.bfk.de (mx01.bfk.de [193.227.124.2]) by mail.postgresql.org (Postfix) with ESMTP id 7EA881335B36 for ; Fri, 19 Nov 2010 09:01:45 -0400 (AST) Received: from mx00.int.bfk.de ([10.119.110.2]) by mx01.bfk.de with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:32) id 1PJQb1-0008Ns-Gh; Fri, 19 Nov 2010 13:01:43 +0000 Received: by bfk.de with local id 1PJQb1-0007aB-CJ; Fri, 19 Nov 2010 13:01:43 +0000 To: Chris Ruprecht Cc: pgsql-admin@postgresql.org Subject: Re: Pre-Allocate tablespace on disk References: <9CB65F11-6FA4-48D5-BCC5-B3F694659965@ruprecht.org> From: Florian Weimer Date: Fri, 19 Nov 2010 13:01:43 +0000 In-Reply-To: <9CB65F11-6FA4-48D5-BCC5-B3F694659965@ruprecht.org> (Chris Ruprecht's message of "Mon\, 15 Nov 2010 14\:42\:46 -0500") Message-ID: <82zkt55ux4.fsf@mid.bfk.de> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201011/153 X-Sequence-Number: 36119 * Chris Ruprecht: > Other database that I have worked with before and that I'm still > working with, allow you to pre-allocate disk space so you get huge > chunks of contiguous space at one, which has major impacts on > database performance. PostgreSQL's write patterns do not trigger significant fragmentation with most file systems, even when other database systems (Oracle Berkeley DB comes to my mind) would create heavily fragmented files. --=20 Florian Weimer BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstra=DFe 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99