Re: Bench marking performance or experience using Solid State Disk Drives (SSD) with postgres

Поиск
Список
Период
Сортировка
От Vick Khera
Тема Re: Bench marking performance or experience using Solid State Disk Drives (SSD) with postgres
Дата
Msg-id 2968dfd60911051249k1324e7bva0bd8aba042fceaa@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Bench marking performance or experience using Solid State Disk Drives (SSD) with postgres  (Howard Cole <howardnews@selestial.com>)
Список pgsql-general
On Thu, Nov 5, 2009 at 8:46 AM, Howard Cole <howardnews@selestial.com> wrote:
> I use a single SSD on one of our servers and it appears to be much more
> responsive than a single 15K SAS drive - Thats as scientific as my testing
> gets! The database I use is mostly reads.
>
> Careful which SSD you choose because there is a wide variation in
> performance.

I have yet to find a anyone that will assert what the write-cycles
these new devices will handle.  Our DB is very high write and read
load, and I have no idea how long the SSDs would last.  They are still
too expensive for me to buy them to do this experiment.

I certainly hope you have good backups for when your SSD does finally croak.

В списке pgsql-general по дате отправления:

Предыдущее
От: "ara.t.howard"
Дата:
Сообщение: adding a custom tsearch parser
Следующее
От: "Bob Pawley"
Дата:
Сообщение: Re: Adding a null