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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How to improve db performance with $7K?
Дата
Msg-id 29785.1113542934@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: How to improve db performance with $7K?  (Kevin Brown <kevin@sysexperts.com>)
Ответы Re: How to improve db performance with $7K?
Список pgsql-performance
Kevin Brown <kevin@sysexperts.com> writes:
> In the case of pure random reads, you'll end up having to wait an
> average of half of a rotation before beginning the read.

You're assuming the conclusion.  The above is true if the disk is handed
one request at a time by a kernel that doesn't have any low-level timing
information.  If there are multiple random requests on the same track,
the drive has an opportunity to do better than that --- if it's got all
the requests in hand.

            regards, tom lane

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

Предыдущее
От: Kevin Brown
Дата:
Сообщение: Re: How to improve db performance with $7K?
Следующее
От: Richard van den Berg
Дата:
Сообщение: Re: Foreign key slows down copy/insert