Re: Slow restoration question

Поиск
Список
Период
Сортировка
От Michael Stone
Тема Re: Slow restoration question
Дата
Msg-id 20060503121847.GN31328@mathom.us
обсуждение исходный текст
Ответ на Re: Slow restoration question  (Brendan Duddridge <brendan@clickspace.com>)
Ответы Re: Slow restoration question  (Jeff Trout <threshar@torgo.978.org>)
Список pgsql-performance
On Tue, May 02, 2006 at 08:09:52PM -0600, Brendan Duddridge wrote:
>               -------Sequential Output-------- ---Sequential Input--  --Random--
>               -Per Char- --Block--- -Rewrite-- -Per Char- --Block---  --Seeks---
>Machine    MB K/sec %CPU K/sec %CPU K/sec %CPU K/sec %CPU K/sec % CPU  /sec %CPU
>             0 40365 99.4 211625 61.4 212425 57.0 50740 99.9 730515  100.0 45897.9 190.1
[snip]
>Do these numbers seem decent enough for a Postgres database?

These numbers seem completely bogus, probably because bonnie is using a
file size smaller than memory and is reporting caching effects. (730MB/s
isn't possible for a single external RAID unit with a pair of 2Gb/s
interfaces.) bonnie in general isn't particularly useful on modern
large-ram systems, in my experience.

Mike Stone

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

Предыдущее
От: Michael Stone
Дата:
Сообщение: Re: Why so slow?
Следующее
От: Jan de Visser
Дата:
Сообщение: Re: Performance Issues on Opteron Dual Core