What filesystem to use for postgres?

Started by A Bover 15 years ago4 messagesgeneral
Jump to latest
#1A B
gentosaker@gmail.com

Hello.

Is there any doc or wiki page that describes what filesystems that are
recomended to use (OS is Linux) for PostgreSQL?
Information about filesystems options/mount options and how well
they work with different RAID setups is also of interest.

#2Bill Moran
wmoran@potentialtech.com
In reply to: A B (#1)
Re: What filesystem to use for postgres?

In response to A B <gentosaker@gmail.com>:

Hello.

Is there any doc or wiki page that describes what filesystems that are
recomended to use (OS is Linux) for PostgreSQL?
Information about filesystems options/mount options and how well
they work with different RAID setups is also of interest.

Wow ... I did this a LONG time ago, so the results need to be taken
with a grain of "that code has assuredly changed since that was done".

http://www.potentialtech.com/wmoran/postgresql.php

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/

#3Aaron
aaron@chasingnuts.com
In reply to: A B (#1)
Re: What filesystem to use for postgres?

Some more current numbers can be found here:
http://wiki.postgresql.org/wiki/HP_ProLiant_DL380_G5_Tuning_Guide

Aaron Thul
http://www.chasingnuts.com

Show quoted text

On Tue, Sep 14, 2010 at 4:00 AM, A B <gentosaker@gmail.com> wrote:

Hello.

Is there any doc or wiki page that describes what filesystems that are
recomended to  use (OS is Linux) for PostgreSQL?
Information about  filesystems options/mount options   and how well
they work with different RAID setups is also of interest.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#4Matthieu Huin
matthieu.huin@wallix.com
In reply to: Bill Moran (#2)
Re: What filesystem to use for postgres?

Greetings,

This wiki entry might be of interest to you:

http://wiki.postgresql.org/wiki/HP_ProLiant_DL380_G5_Tuning_Guide

I don't know how up to date these benchmarks are though.

Matthieu Huin

Le mardi 14 septembre 2010 à 08:35 -0400, Bill Moran a écrit :

Show quoted text

In response to A B <gentosaker@gmail.com>:

Hello.

Is there any doc or wiki page that describes what filesystems that are
recomended to use (OS is Linux) for PostgreSQL?
Information about filesystems options/mount options and how well
they work with different RAID setups is also of interest.

Wow ... I did this a LONG time ago, so the results need to be taken
with a grain of "that code has assuredly changed since that was done".

http://www.potentialtech.com/wmoran/postgresql.php

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/