Postgres Pro
Downloads
Home   >   mailing lists

Re: Pre-Allocate tablespace on disk - Mailing list pgsql-admin

From Florian Weimer
Subject Re: Pre-Allocate tablespace on disk
Date
Msg-id 82zkt55ux4.fsf@mid.bfk.de
Whole thread Raw
In response to Pre-Allocate tablespace on disk  (Chris Ruprecht <chris@ruprecht.org>)
Responses Re: Pre-Allocate tablespace on disk  (Steve Francis <sfrancis@logicmonitor.com>)
List pgsql-admin
Tree view 
* 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@bfk.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

pgsql-admin by date:

Previous
From: ojas dubey
Date:
Subject: Re: Find all running postgres DB servers on a network
Next
From: Steve Francis
Date:
Subject: Re: Pre-Allocate tablespace on disk