Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance Tuning Article - Mailing list pgsql-performance

From Michael Stone
Subject Re: Performance Tuning Article
Date
Msg-id 20050623144452.GB9591@mathom.us
Whole thread Raw
In response to Re: Performance Tuning Article  (Keith Worthington <KeithW@NarrowPathInc.com>)
List pgsql-performance
Tree view 
On Wed, Jun 22, 2005 at 10:31:29PM -0400, Keith Worthington wrote:
>Use RAID 10 (striping across mirrored disks)
>  or RAID 0+1 (mirror a striped array) for your data.

yikes! never tell an unsuspecting person to use mirred stripes--that
configuration has lower reliability and performance than striped mirrors
with no redeeming qualities.

Mike Stone

pgsql-performance by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: parameterized LIKE does not use index
Next
From: Elliott Bennett
Date:
Subject: select distinct on varchar - wild performance differences!