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 DA19356410 for ; Sat, 12 Mar 2005 02:21:28 +0000 (GMT) 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 46000-02 for ; Sat, 12 Mar 2005 02:21:26 +0000 (GMT) Received: from r163ip.btv.lv (r163ip.btv.lv [217.198.224.163]) by svr1.postgresql.org (Postfix) with ESMTP id 7225456474 for ; Sat, 12 Mar 2005 02:21:24 +0000 (GMT) Received: from p4 (pIV.homenet [192.168.88.4]) by r163ip.btv.lv (8.12.9/8.12.6) with ESMTP id j2C2LP3A041247 for ; Sat, 12 Mar 2005 04:21:27 +0200 (EET) (envelope-from postgres@bilteks.com) From: "Alexander Kirpa" To: pgsql-performance@postgresql.org Date: Sat, 12 Mar 2005 04:21:29 +0200 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: Re: Postgres on RAID5 Message-ID: <42326E49.18978.3A504719@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: 200503/237 X-Sequence-Number: 10942 Hi Arshavir Grigorian, 0. If possible move to 8.0.1 - bgwriter help you 1. Create RAID1 for redo and place drives on separate SCSI channel 2. Update postgresql.conf: shared_buffers = 10000-50000 work_mem = 100000-300000 maintenance_work_mem = 100000-300000 max_fsm_pages = 1500000 max_fsm_relations = 16000 wal_buffers = 32 checkpoint_segments = 32 # 16MB each !! checkpoint_timeout = 600 checkpoint_warning = 60 effective_cache_size = 128000 random_page_cost = 3 default_statistics_target = 100 log_min_error_statement = warning log_min_duration_statement = 1000 # for logging long SQL 3. If possible migrate from RAID5 to RAID10. 4. Add (if need) 2 new drive for OS and use ALL 20x9GB drive for DB storage. 5. Remove CDROM from work configuration and start use this scsi channel. Best regards, Alexander Kirpa