Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD
Дата
Msg-id 4C617DE8.4030203@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD  (Jeff Davis <pgsql@j-davis.com>)
Список 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 по дате отправления:

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: Sorted group by
Следующее
От: Thom Brown
Дата:
Сообщение: Re: Sorted group by