| From: | "Anjan Dave" <adave(at)vantage(dot)com> |
|---|---|
| To: | <pgsql-performance(at)postgresql(dot)org> |
| Subject: | SAN performance |
| Date: | 2004-09-22 21:49:02 |
| Message-ID: | 4BAFBB6B9CC46F41B2AD7D9F4BBAF785018B4049@vt-pe2550-001.vantage.vantage.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hello,
I'll be moving a DB from internal RAID-10 SCSI storage to an EMC CX300
FC RAID-10 LUN, bound to the host. I've setup a test host machine and a
test LUN. The /var/lib/pgsql/data folder is sym-linked to a partition on
the LUN.
Other than the shared_buffers, effective cache size, and sort memory, I
am not sure if I need to change any other parameters in the
postgresql.conf file for getting maximum performance from the EMC box.
Is there a general guideline for setting up postgres database and the
tunable parameters on a SAN, especially for EMC?
Appreciate any help,
Thanks,
Anjan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-09-22 22:03:45 | Re: Fw: Infinite CPU loop due to field ::type casting, Take II :-) |
| Previous Message | Aaron Werman | 2004-09-22 21:43:16 | Re: Caching of Queries |