Re: Maximum Possible Insert Performance?

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Maximum Possible Insert Performance?
Дата
Msg-id 87brr11c44.fsf@stark.dyndns.tv
обсуждение исходный текст
Ответ на Re: Maximum Possible Insert Performance?  (William Yu <wyu@talisys.com>)
Ответы Re: Maximum Possible Insert Performance?  (Suchandra Thapa <ssthapa@netzero.com>)
Список pgsql-performance
William Yu <wyu@talisys.com> writes:

> > You're right, though, mirroring a solid state drive is pretty pointless; if
> > power fails, both mirrors are dead.
>
> Actually no. Solid state memory is non-volatile. They retain data even without
> power.

Note that flash ram only has a finite number of write cycles before it fails.

On the other hand that might not be so bad for WAL which writes sequentially,
you can easily calculate how close you are to the maximum. For things like
heap storage or swap it's awful as you can get hot spots that get written to
thousands of times before the rest of the space is used.

--
greg

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

Предыдущее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Where to start for performance problem?
Следующее
От: Neil Conway
Дата:
Сообщение: Re: Optimize