Re: Segment best size - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Segment best size
Date
Msg-id CAOR=d=2a9jOV+jwyZoN+roh7gRhpK0SpkT8mxvAgeozc-VpCPA@mail.gmail.com
Whole thread Raw
In response to Re: Segment best size  (Rodrigo Barboza <rodrigombufrj@gmail.com>)
List 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 by date:

Previous
From: Rodrigo Barboza
Date:
Subject: Re: Segment best size
Next
From: Rikard Pavelic
Date:
Subject: Re: limit is sometimes not pushed in view with order