shared_buffers and effective_cache_size

Поиск
Список
Период
Сортировка
От Zhang, Anna
Тема shared_buffers and effective_cache_size
Дата
Msg-id 5511D658682A7740BA295CCF1E1233A635A85C@vsvapostal2.bkup3
обсуждение исходный текст
Ответы Re: shared_buffers and effective_cache_size  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-admin
Hi,
I just got a new Penguin machine with 2 processors and 2G RAM. After
installed postgres 7.2, I started to modify postgresql.conf to get max
performance. I read Adm Guide and Bruce's article: PostgreSQL Hardware
Performance Tuning, in my understanding, shared_buffers is similar to
Oracle's db_block_buffers, but also sometimes I feel it sounds like oracle's
SGA. When I reached effective_cache_size, don't know what's that, docs can't
help, it seems for optimizer, but how big should I set? no feeling! Does
anyone can compare this paremeter to oracle's so I can understand better.

If I set  SHARED_BUFFERS = 131072,  what effective_cache_size should be?


Thanks!


Anna Zhang



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

Предыдущее
От: Brian McCane
Дата:
Сообщение: Strange locking behaviour
Следующее
От: s.chava@wcom.com (Srinivasa Rao Chava)
Дата:
Сообщение: plpgsql error