From: Alexander Kirpa <postgres@bilteks.com>
To: pgsql-performance@postgresql.org
Subject: Re: Data Warehousing Tuning
Date: Mon, 11 Jul 2005 01:07:14 +0300
Message-ID: <42D1C642.16182.39B63C29@localhost> (raw)
>- 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: postgres@bilteks.com
Subject: Re: Data Warehousing Tuning
In-Reply-To: <42D1C642.16182.39B63C29@localhost>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox