Re: testing HS/SR - 1 vs 2 performance

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: testing HS/SR - 1 vs 2 performance
Дата
Msg-id m2j3f0b79eb1004120206i3de076f7j5efcdabcb353c73b@mail.gmail.com
обсуждение исходный текст
Ответ на testing HS/SR - 1 vs 2 performance  ("Erik Rijkers" <er@xs4all.nl>)
Ответы Re: testing HS/SR - 1 vs 2 performance
Список pgsql-hackers
Дерево обсуждения 
On Sat, Apr 10, 2010 at 8:23 AM, Erik Rijkers <er@xs4all.nl> wrote:
> I understand that in the scale=1000 case, there is a huge
> cache effect, but why doesn't that apply to the pgbench runs
> against the standby?  (and for the scale=10_000 case the
> differences are still rather large)

I guess that this performance degradation happened because a number of
buffer replacements caused UpdateMinRecoveryPoint() often. So I think
increasing shared_buffers would improve the performance significantly.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

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

Предыдущее
От: Boszormenyi Zoltan
Дата:
Сообщение: Re: pg_ctl stop -m immediate on the primary server inflates sequences
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Streaming replication and a disk full in primary