Re: [PERFORM] Solaris 9 tuning

Hi Josh, there are 8 internal disks - all are [EMAIL PROTECTED],000 RPM, fibre connected. The O/S is on 2 mirrored disks, the Postgres cluster is on the /data1 filesystem that is striped across the other 6 disks. The shared_buffers value is a semi-educated guess based on having made 4GB shared

Re: [PERFORM] Solaris 9 tuning

hme:hme_adv_100hdx_cap=0 set hme:hme_adv_10fdx_cap=0 set hme:hme_adv_10hdx_cap=0 set hme:hme_adv_100T4_cap=0 Paul Johnson wrote: Hi Josh, there are 8 internal disks - all are [EMAIL PROTECTED],000 RPM, fibre connected. The O/S is on 2 mirrored disks, the Postgres cluster is on the /data1

[PERFORM] Data Warehousing Tuning

Hi all, we have the following setup: - Sun V250 server - 2*1.3GHz Sparc IIIi CPU - 8GB RAM - 8*73GB SCSI drives - Solaris 10 - Postgres 8 Disks 0 and 1 are mirrored and contain the OS and the various software packages, disks 2-7 are configured as a 320GB concatenation mounted on /data, which is

[PERFORM] PG8 Tuning

such as this, where an external storage array with a hardware RAID controller is used, the normal advice to separate the data from the pg_xlog seems to come unstuck, or are we missing something? Cheers, Paul Johnson. ---(end of broadcast)--- TIP 4