Re: sniff test on some PG 8.4 numbers

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: sniff test on some PG 8.4 numbers
Дата
Msg-id 5136958F.5050508@agliodbs.com
обсуждение исходный текст
Ответ на sniff test on some PG 8.4 numbers  (Jon Nelson <jnelson+pgsql@jamponi.net>)
Ответы Re: sniff test on some PG 8.4 numbers  (Jon Nelson <jnelson+pgsql@jamponi.net>)
Список pgsql-performance
> Do these basically sniff right?

Well, the read test seems reasonable.  I'm impressed by the speed of the
write test ... how large is the raid card cache?

And why 8.4?  Can you try 9.2?

> (NOTE: with barriers off, I get a slight increase - 10% - in the
> read-write test, and a larger *decrease* - 15% - with the read-only
> test @ 400. No change @ 100)

Oh, interesting.  Can you reproduce that? I wonder what would cause
read-only to drop without barriers ...

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...)
Следующее
От: Jon Nelson
Дата:
Сообщение: Re: sniff test on some PG 8.4 numbers