Re: Shared buffers, db transactions commited, and write IO on Solaris

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Shared buffers, db transactions commited, and write IO on Solaris
Дата
Msg-id 200703291723.24061.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: Shared buffers, db transactions commited, and write IO on Solaris  (Dimitri <dimitrik.fr@gmail.com>)
Ответы Re: Shared buffers, db transactions commited, and write IO on Solaris  (Erik Jones <erik@myemma.com>)
Список pgsql-performance
Erik,

Wow, thanks for the post.

We've just started testing the option of sizing shared_buffers bigger than
the database, and using forcedirectio in benchmarks at Sun.  So far, our
experience has been *equal* performance in that configuration, so it's
*very* interesting to see you're getting a gain.

--
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco

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

Предыдущее
От: "Dave Dutcher"
Дата:
Сообщение: Re: Planner doing seqscan before indexed join
Следующее
От: david@lang.hm
Дата:
Сообщение: Re: Sunfire X4500 recommendations