From: Alexander Kirpa <postgres@bilteks.com>
To: pgsql-performance@postgresql.org
Subject: Re: Postgres on RAID5
Date: Sat, 12 Mar 2005 04:21:29 +0200
Message-ID: <42326E49.18978.3A504719@localhost> (raw)
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
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: Postgres on RAID5
In-Reply-To: <42326E49.18978.3A504719@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