Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD - Mailing list pgsql-performance

From Greg Smith
Subject Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD
Date
Msg-id 4C617DE8.4030203@2ndquadrant.com
Whole thread Raw
In response to Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-performance
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


pgsql-performance by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Sorted group by
Next
From: Thom Brown
Date:
Subject: Re: Sorted group by