pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (26+ messages)  latest in thread

Message-ID: <42326E49.18978.3A504719@localhost>
Permalink:  ../42326E49.18978.3A504719@localhost/
Also on:    postgresql.org/message-id/42326E49.18978.3A504719@localhost

 · 

reply

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