Re: Data Warehousing Tuning - Mailing list pgsql-performance

From Alexander Kirpa
Subject Re: Data Warehousing Tuning
Date
Msg-id 42D1C642.16182.39B63C29@localhost
Whole thread Raw
In response to Data Warehousing Tuning  ("Paul Johnson" <paul@oxton.com>)
List 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



pgsql-performance by date:

Previous
From: "jobapply"
Date:
Subject: Sorting on longer key is faster ?
Next
From: John A Meinel
Date:
Subject: Re: join and query planner