Обсуждение: What filesystem to use for postgres?
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.
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/
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 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 >
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 : > 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/ >