Re: inferior SCSI performance

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: inferior SCSI performance
Дата
Msg-id Pine.LNX.4.33.0310010713250.20754-100000@css120.ihs.com
обсуждение исходный текст
Ответ на Re: inferior SCSI performance  (Andrew Sullivan <andrew@libertyrms.info>)
Ответы Re: inferior SCSI performance  (Andrew Sullivan <andrew@libertyrms.info>)
Список pgsql-performance
On Wed, 1 Oct 2003, Andrew Sullivan wrote:

> On Wed, Sep 17, 2003 at 04:46:00PM -0400, Michael Adler wrote:
> > So the quesiton is whether it is ever sensible to use write-caching and
> > expect comparable persistence.
>
> Yes.  If and only if you have a battery-backed cache.  I know of no
> IDE drives that have that, but there's nothing about the spec which
> makes it impossible.

FYI, on a Dual PIV2800 with 2 gig ram and a single UDMA 80 gig hard drive,
I from 420 tps to 22 tps when I disable write caching.  WOW.  A factor of
about 20 times slower.  (pgbench -c 4 -t 100)


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

Предыдущее
От: "Mindaugas Riauba"
Дата:
Сообщение: Re: What is the fastest null WHERE
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: inferior SCSI performance