Postgres on polyserve cluster file system

From: "Bhella Paramjeet-PFCW67" <PBhella(at)Motorola(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Postgres on polyserve cluster file system
Date: 2008-08-01 18:59:52
Message-ID: C84662912D280D4AB5C50100A100F0C5038C58BB@ct11exm61.ds.mot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

We are going to be moving our production postgres databases to new SAN
with polyserve clustering filesystem. Can anyone running postgres on
polyserver tell us what file system mount options should we use to get
best performance?

Our existing san with ext3 filesystem mounted with "
rw,noatime,data=writeback " gives us good performance. In our new san
with polyserve we have mounted files with options "psfs
rw,dboptimize,shared,data=ordered " and we are getting poor performance
as compared to existing san with ext3. For eg: A restore of a 15 G
database on our existing san with ext3 take 45 min but the same restore
on san with ployserver takes 1 hr 40 mins. I used the wal_sync_method =
fdatasync and still the restore time with polyserve was 1 hr 40 mins.
Removing the dboptimize option gave little better performance but was
still half hour more compared to etx3. So can some one please suggest
what mount options should we use to get good performance out of
polyserve. Any help will be appreciated.

Thanks
Paramjeet Bhella

Browse pgsql-admin by date

  From Date Subject
Next Message C K 2008-08-02 09:39:50 functions
Previous Message Richard Huxton 2008-08-01 08:43:44 Re: [PERFORM] Nls sorting in Postgresql-8.3.3