From: Greg Smith <greg@2ndquadrant.com>
To: Jeff Davis <pgsql@j-davis.com>
Cc: Scott Carey <scott@richrelevance.com>
Cc: Michael March <mmarch@gmail.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD
Date: Tue, 10 Aug 2010 12:27:20 -0400
Message-ID: <4C617DE8.4030203@2ndquadrant.com> (raw)
In-Reply-To: <1281393719.3667.8.camel@jdavis-ux.asterdata.local>
References: <AANLkTikXLYc32Jyr5Fb8VeVNt6R86mCcF+0CkTHALd8W@mail.gmail.com>
<BAE01AAD-6C69-48C7-BD2E-77E463D49903@richrelevance.com>
<AANLkTi=km+H+mZ=yyx0_HTFZ-yU2sh85D+p5cs+ZcUSF@mail.gmail.com>
<A1640F99-A7C5-4F04-9A25-782C46BE7DAB@richrelevance.com>
<1281393719.3667.8.camel@jdavis-ux.asterdata.local>
Jeff Davis wrote:
> Depending on which 256K you lose, you might as well lose your entire
> database.
>
Let's be nice and assume that you only lose one 8K block because of the
SSD write cache; that's not so bad, right? Guess what--you could easily
be the next lucky person who discovers the block corrupted is actually
in the middle of the pg_class system catalog, where the list of tables
in the database is at! Enjoy getting your data back again with that
piece missing. It's really a fun time, I'll tell you that.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.us
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: greg@2ndquadrant.com, pgsql@j-davis.com, scott@richrelevance.com, mmarch@gmail.com
Subject: Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD
In-Reply-To: <4C617DE8.4030203@2ndquadrant.com>
* 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