Re: Pre-Allocate tablespace on disk

From: Florian Weimer <fweimer(at)bfk(dot)de>
To: Chris Ruprecht <chris(at)ruprecht(dot)org>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Pre-Allocate tablespace on disk
Date: 2010-11-19 13:01:43
Message-ID: 82zkt55ux4.fsf@mid.bfk.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

* 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.

--
Florian Weimer <fweimer(at)bfk(dot)de>
BFK edv-consulting GmbH http://www.bfk.de/
Kriegsstraße 100 tel: +49-721-96201-1
D-76133 Karlsruhe fax: +49-721-96201-99

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Steve Francis 2010-11-19 19:42:44 Re: Pre-Allocate tablespace on disk
Previous Message bakkiya raj 2010-11-19 12:47:09 ERROR: could not open relation with OID