Re: How to improve db performance with $7K?

Поиск
Список
Период
Сортировка
От Rosser Schwarz
Тема Re: How to improve db performance with $7K?
Дата
Msg-id 37d451f7050414074876acdb82@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to improve db performance with $7K?  (Kevin Brown <kevin@sysexperts.com>)
Ответы Re: How to improve db performance with $7K?  (Kevin Brown <kevin@sysexperts.com>)
Список pgsql-performance
while you weren't looking, Kevin Brown wrote:

[reordering bursty reads]

> In other words, it's a corner case that I strongly suspect
> isn't typical in situations where SCSI has historically made a big
> difference.

[...]

> But I rather doubt that has to be a huge penalty, if any.  When a
> process issues an fsync (or even a sync), the kernel doesn't *have* to
> drop everything it's doing and get to work on it immediately.  It
> could easily gather a few more requests, bundle them up, and then
> issue them.

To make sure I'm following you here, are you or are you not suggesting
that the kernel could sit on -all- IO requests for some small handful
of ms before actually performing any IO to address what you "strongly
suspect" is a "corner case"?

/rls

--
:wq

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

Предыдущее
От: "Joel Fradkin"
Дата:
Сообщение: Re: speed of querry?
Следующее
От: Greg Stark
Дата:
Сообщение: Intel SRCS16 SATA raid?