Re: Segment best size

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Segment best size
Дата
Msg-id CAOR=d=2a9jOV+jwyZoN+roh7gRhpK0SpkT8mxvAgeozc-VpCPA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Segment best size  (Rodrigo Barboza <rodrigombufrj@gmail.com>)
Список pgsql-performance
On Sat, Apr 13, 2013 at 9:01 PM, Rodrigo Barboza
<rodrigombufrj@gmail.com> wrote:

> Would it help if I changed the checkpoint_completion_target to something close to 0.7 (mine is the default 0.5) or
raisethe checkpoint_segments (it is 32 now)? 

That depends. What are your access patterns like? Do you have 1 or 2
writers, a dozen, a hundred? If you've got hundreds of active writers
then look at pooling an also commit_siblings and commit_delay.


--
To understand recursion, one must first understand recursion.


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

Предыдущее
От: Rodrigo Barboza
Дата:
Сообщение: Re: Segment best size
Следующее
От: Rikard Pavelic
Дата:
Сообщение: Re: limit is sometimes not pushed in view with order