Re: [PERFORM] Segment best size

2013-04-14 Thread Rodrigo Barboza
On Sun, Apr 14, 2013 at 7:34 PM, Jeff Janes wrote: > On Saturday, April 13, 2013, Rodrigo Barboza wrote: > >> >> >> >> On Sat, Apr 13, 2013 at 4:51 PM, Jeff Janes wrote: >> >>> On Sat, Apr 13, 2013 at 10:29 AM, Rodrigo Barboza < >>> rodrigombu...@gmail.com> wrote: >>> I was receiv

Re: [PERFORM] Segment best size

2013-04-14 Thread Jeff Janes
On Saturday, April 13, 2013, Rodrigo Barboza wrote: > > > > On Sat, Apr 13, 2013 at 4:51 PM, Jeff Janes > > > wrote: > >> On Sat, Apr 13, 2013 at 10:29 AM, Rodrigo Barboza < >> rodrigombu...@gmail.com > 'rodrigombu...@gmail.com');>> wrote: >> >>> >>> >>> I was receiving warning messages of pgsta

Re: [PERFORM] Segment best size

2013-04-13 Thread Scott Marlowe
On Sat, Apr 13, 2013 at 9:01 PM, Rodrigo Barboza wrote: > Would it help if I changed the checkpoint_completion_target to something > close to 0.7 (mine is the default 0.5) or raise the checkpoint_segments (it > is 32 now)? That depends. What are your access patterns like? Do you have 1 or 2 wr

Re: [PERFORM] Segment best size

2013-04-13 Thread Rodrigo Barboza
On Sat, Apr 13, 2013 at 4:51 PM, Jeff Janes wrote: > On Sat, Apr 13, 2013 at 10:29 AM, Rodrigo Barboza > wrote: > >> >> >> I was receiving warning messages of pgstat timeout. >> I started looking for the solution for this problem and this doubt came >> out. >> But it doesn't seem to be the probl

Re: [PERFORM] Segment best size

2013-04-13 Thread Jeff Janes
On Sat, Apr 13, 2013 at 10:29 AM, Rodrigo Barboza wrote: > > > I was receiving warning messages of pgstat timeout. > I started looking for the solution for this problem and this doubt came > out. > But it doesn't seem to be the problem. > Usually that just means that you are dirtying pages faster

Re: [PERFORM] Segment best size

2013-04-13 Thread Rodrigo Barboza
On Fri, Apr 12, 2013 at 10:20 PM, Jeff Janes wrote: > On Friday, April 12, 2013, Rodrigo Barboza wrote: > >> Hi guys. >> I compiled my postrges server (9.1.4) with default segment size (16MB). >> Should it be enough? Should I increase this size in compilation? >> > > To recommend that you deviate

Re: [PERFORM] Segment best size

2013-04-12 Thread Jeff Janes
On Friday, April 12, 2013, Rodrigo Barboza wrote: > Hi guys. > I compiled my postrges server (9.1.4) with default segment size (16MB). > Should it be enough? Should I increase this size in compilation? > To recommend that you deviate from the defaults, we would have to know something about your s

Re: [PERFORM] Segment best size

2013-04-12 Thread Rodrigo Barboza
On Fri, Apr 12, 2013 at 2:52 PM, Ben Chobot wrote: > On Apr 12, 2013, at 9:45 AM, Rodrigo Barboza wrote: > > > Hi guys. > > I compiled my postrges server (9.1.4) with default segment size (16MB). > > Should it be enough? Should I increase this size in compilation? > > Unlike some default values i

Re: [PERFORM] Segment best size

2013-04-12 Thread Ben Chobot
On Apr 12, 2013, at 9:45 AM, Rodrigo Barboza wrote: > Hi guys. > I compiled my postrges server (9.1.4) with default segment size (16MB). > Should it be enough? Should I increase this size in compilation? Unlike some default values in the configuration file, the compiled-in defaults work well for

[PERFORM] Segment best size

2013-04-12 Thread Rodrigo Barboza
Hi guys. I compiled my postrges server (9.1.4) with default segment size (16MB). Should it be enough? Should I increase this size in compilation?