From: | "Anjan Dave" <adave(at)vantage(dot)com> |
---|---|
To: | <pgsql-performance(at)postgresql(dot)org> |
Subject: | separate drives for WAL or pgdata files |
Date: | 2005-12-19 20:04:24 |
Message-ID: | 4BAFBB6B9CC46F41B2AD7D9F4BBAF785098F10@vt-pe2550-001.vantage.vantage.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hi,
I am not sure if there's an obvious answer to this...If there's a choice
of an external RAID10 (Fiber Channel 6 or 8 15Krpm drives) enabled
drives, what is more beneficial to store on it, the WAL, or the Database
files? One of the other would go on the local RAID10 (4 drives, 15Krpm)
along with the OS.
This is a very busy database with high concurrent connections, random
reads and writes. Checkpoint segments are 300 and interval is 6 mins.
Database size is less than 50GB.
It has become a bit more confusing because I am trying to allot shared
storage across several hosts, and want to be careful not to overload one
of the 2 storage processors.
What should I check/monitor if more information is needed to determine
this?
Appreciate some suggestions.
Thanks,
Anjan
This email message and any included attachments constitute confidential
and privileged information intended exclusively for the listed
addressee(s). If you are not the intended recipient, please notify
Vantage by immediately telephoning 215-579-8390, extension 1158. In
addition, please reply to this message confirming your receipt of the
same in error. A copy of your email reply can also be sent to
mailto:support(at)vantage(dot)com <blocked::mailto:support(at)vantage(dot)com> .
Please do not disclose, copy, distribute or take any action in reliance
on the contents of this information. Kindly destroy all copies of this
message and any attachments. Any other use of this email is prohibited.
Thank you for your cooperation. For more information about Vantage,
please visit our website at http://www.vantage.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Jignesh Shah | 2005-12-19 20:21:06 | Re: PostgreSQL and Ultrasparc T1 |
Previous Message | Luke Lonergan | 2005-12-19 19:37:15 | Re: PostgreSQL and Ultrasparc T1 |