| From: | "Alexander Kirpa" <postgres(at)bilteks(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Data Warehousing Tuning |
| Date: | 2005-07-10 22:07:14 |
| Message-ID: | 42D1C642.16182.39B63C29@localhost |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
>- Sun V250 server
>- 2*1.3GHz Sparc IIIi CPU
>- 8GB RAM
>- 8*73GB SCSI drives
>- Solaris 10
>- Postgres 8
>4) We moved the pg_xlog files off /data/postgres (disks 2-7) and into
>/opt/pg_xlog (disks 0-1), but it seemed like performance decreased,
>so we moved them back again.
You have saturated SCSI bus.
1x160GB/s SCSI too small for 8xHDD with 30-70MB/s
Solutions:
Replace CD/DVD/tape at top 2x5" slots on 2xHDD (320 SCSI),
install PCI 64/66 SCSI 320 controller
(or simple RAID1 controller for minimize
saturation of PCI buses)
and attach to 2xHDD. Move /opt/pg_xlog on this drives.
Best regards,
Alexander Kirpa
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2005-07-11 11:31:44 | Re: cost-based vacuum |
| Previous Message | Christopher Browne | 2005-07-10 04:54:37 | Re: Mount database on RAM disk? |