Re: Help tuning postgres - Mailing list pgsql-performance

From Markus Wollny
Subject Re: Help tuning postgres
Date
Msg-id 2266D0630E43BB4290742247C8910575082D361D@dozer.computec.de
Whole thread Raw
In response to Help tuning postgres  (Csaba Nagy <nagy@ecircle-ag.com>)
List pgsql-performance
pgsql-performance-owner@postgresql.org wrote:

> Next we'll upgrade the postgres hardware, and then I'll come
> back to report if it's working better... sorry for the noise for now.

There have been some discussions about which hardware suits PostgreSQL's
needs best under certain load-characteristics. We have experienced quite
a write-performance burst just from switching from a RAID5-config to a
RAID10 (mirroring&striping), even though we had been using some
supposedly sufficiently powerful dedicated battery-backuped
SCSI-RAID-adapters with lots of on-board cache. You can't beat simple,
although it will cost disk-space. Anyway, you might want to search the
archives for discussion on RAID-configurations.

pgsql-performance by date:

Previous
From: "Markus Wollny"
Date:
Subject: Re: Help tuning postgres
Next
From: Richard Huxton
Date:
Subject: Re: Optimizer misconfigured ?