Re: Filesystem benchmarking for pg 8.3.3 server

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Filesystem benchmarking for pg 8.3.3 server
Дата
Msg-id dcc563d10808130748m3a8fe7f8n2a64965990317697@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Filesystem benchmarking for pg 8.3.3 server  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
Ответы Re: Filesystem benchmarking for pg 8.3.3 server
Список pgsql-performance
On Wed, Aug 13, 2008 at 8:41 AM, Ron Mayer
<rm_pg@cheapcomplexdevices.com> wrote:
> Greg Smith wrote:

> But I still am looking for any evidence that there were any
> widely shipped SATA (or even IDE drives) that were at fault,
> as opposed to filesystem bugs and poor settings of defaults.

Well, if they're getting more than 150/166.6/250 transactions per
second without a battery backed cache, then they're likely lying about
fsync.  And most SATA and IDE drives will give you way over that for a
small data set.

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

Предыдущее
От: Ron Mayer
Дата:
Сообщение: Re: Filesystem benchmarking for pg 8.3.3 server
Следующее
От: Decibel!
Дата:
Сообщение: Re: query plan, index scan cost