pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Pete de Zwart <dezwart@froob.net>
To: pgsql-performance@postgresql.org
Subject: Best filesystem for PostgreSQL Database Cluster under Linux
Date: Tue, 11 Jan 2005 20:23:25 +1100
Message-ID: <41e39b04$0$96857$c30e37c6@ken-reader.news.telstra.net> (raw)

Greetings to one and all,

    I've been trying to find some information on selecting an optimal 
filesystem setup for a volume that will only contain a PostgreSQL Database 
Cluster under Linux. Searching through the mailing list archive showed some 
promising statistics on the various filesystems available to Linux, ranging 
from ext2 through reiserfs and xfs.

    I have come to understand that PostgreSQLs Write Ahead Logging (WAL) 
performs a lot of the journal functionality provided by the majoirty of 
contemporary filesystems and that having both WAL and filesystem journalling 
can degrade performance.

    Could anyone point me in the right direction so that I can read up some 
more on this issue to discern which filesystem to choose and how to tune 
both the FS and PostgreSQL so that they can compliment each other? I've 
attempted to find this information via the FAQ, Google and the mailing list 
archives but have lucked out for the moment.

    Regards,

        Pete de Zwart. 





view thread (4+ messages)  latest in thread

Message-ID: <41e39b04$0$96857$c30e37c6@ken-reader.news.telstra.net>
Permalink:  ../41e39b04$0$96857$c30e37c6@ken-reader.news.telstra.net/
Also on:    postgresql.org/message-id/41e39b04$0$96857$c30e37c6@ken-reader.news.telstra.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: dezwart@froob.net
  Subject: Re: Best filesystem for PostgreSQL Database Cluster under Linux
  In-Reply-To: <41e39b04$0$96857$c30e37c6@ken-reader.news.telstra.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox