Re: understanding postgres issues/bottlenecks

Поиск
Список
Период
Сортировка
От Markus Wanner
Тема Re: understanding postgres issues/bottlenecks
Дата
Msg-id 4968F06B.1020601@bluegap.ch
обсуждение исходный текст
Ответ на Re: understanding postgres issues/bottlenecks  (david@lang.hm)
Ответы Re: understanding postgres issues/bottlenecks  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Re: understanding postgres issues/bottlenecks  (david@lang.hm)
Список pgsql-performance
Hi,

david@lang.hm wrote:
> On Sat, 10 Jan 2009, Gregory Stark wrote:
>> I think the idea is that with SSDs or a RAID with a battery backed
>> cache you
>> can leave fsync on and not have any significant performance hit since
>> the seek
>> times are very fast for SSD. They have limited bandwidth but bandwidth
>> to the
>> WAL is rarely an issue -- just latency.

That's also my understanding.

> with SSDs having extremely good read speeds, but poor (at least by
> comparison) write speeds I wonder if any of the RAID controllers are
> going to get a mode where they cache writes, but don't cache reads,
> leaving all ofyour cache to handle writes.

My understanding of SSDs so far is, that they are not that bad at
writing *on average*, but to perform wear-leveling, they sometimes have
to shuffle around multiple blocks at once. So there are pretty awful
spikes for writing latency (IIRC more than 100ms has been measured on
cheaper disks).

A battery backed cache could theoretically flatten those, as long as
your avg. WAL throughput is below the SSDs avg. writing throughput.

Regards

Markus Wanner

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

Предыдущее
От: david@lang.hm
Дата:
Сообщение: Re: understanding postgres issues/bottlenecks
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: understanding postgres issues/bottlenecks