X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 33BEB52B80 for ; Sun, 10 Jul 2005 19:07:29 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 10162-01 for ; Sun, 10 Jul 2005 22:07:20 +0000 (GMT) Received: from r163ip.btv.lv (r163ip.btv.lv [217.198.224.163]) by svr1.postgresql.org (Postfix) with ESMTP id BF84352ABB for ; Sun, 10 Jul 2005 19:07:18 -0300 (ADT) Received: from p4 (pIV.homenet [192.168.88.4]) by r163ip.btv.lv (8.12.9/8.12.6) with ESMTP id j6AM7Ep6073933 for ; Mon, 11 Jul 2005 01:07:18 +0300 (EEST) (envelope-from postgres@bilteks.com) From: "Alexander Kirpa" To: pgsql-performance@postgresql.org Date: Mon, 11 Jul 2005 01:07:14 +0300 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: Re: Data Warehousing Tuning Message-ID: <42D1C642.16182.39B63C29@localhost> X-mailer: Pegasus Mail for Win32 (v3.12c) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200507/113 X-Sequence-Number: 13354 >- 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