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
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,
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2004-09-22 22:03:45|
|Subject: Re: Fw: Infinite CPU loop due to field ::type casting, Take II :-) |
|Previous:||From: Aaron Werman||Date: 2004-09-22 21:43:16|
|Subject: Re: Caching of Queries|