Re: ideal storage configuration

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: Samuel Gendler <sgendler(at)ideasculptor(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: ideal storage configuration
Date: 2010-06-30 13:52:09
Message-ID: 4C2B4C09.4030500@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Samuel Gendler wrote:
> 6 internal drives on battery backed raid (I don't know what RAID level
> - is there a way to discover this?), all in a single filesystem, so
> WAL and data are on the same filesystem. I don't believe that we are
> taking advantage of the battery backed controller, since I only see
> this in /etc/fstab:
>
> UUID=12dcd71d-8aec-4253-815c-b4883195eeb8 / ext3
> defaults 1 1
>

That doesn't tell you anything about whether the card's write cache is
being used or not. What you need to do is install the monitoring tools
provided by the manufacturer of the card, which will let you check both
the RAID level and how the cache is setup. I can't give any more
specific instructions because you left out a vital piece of system
information: what RAID card you actually have.

--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.us

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Brad Nicholson 2010-06-30 14:30:57 Re: PostgreSQL as a local in-memory cache
Previous Message Matthew Wakeling 2010-06-30 09:56:48 Re: ideal storage configuration