Re: Very high effective_cache_size == worse performance?

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Very high effective_cache_size == worse performance?
Дата
Msg-id h2xdcc563d11004201224wc7471e0dx335ab345d37f04ca@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Very high effective_cache_size == worse performance?  (David Kerr <dmk@mr-paradox.net>)
Список pgsql-performance
Дерево обсуждения 
On Tue, Apr 20, 2010 at 12:28 PM, David Kerr <dmk@mr-paradox.net> wrote:
> On Tue, Apr 20, 2010 at 12:23:51PM -0600, Scott Marlowe wrote:
> - So are you logging to the same drive that has pg_xlog and your
> - data/base directory on this machine?
> -
>
> the db, xlog and logs are all on separate areas of the SAN.
>
> separate I/O controllers, etc on the SAN. it's setup well, I wouldn't expect
> contention there.

Same xkb/s gigabit connection?

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Very high effective_cache_size == worse performance?
Следующее
От: Dave Crooke
Дата:
Сообщение: Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set