Re: Segment best size

From: Rodrigo Barboza <rodrigombufrj(at)gmail(dot)com>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Segment best size
Date: 2013-04-13 17:29:13
Message-ID: CANs8QJYuQbF=qQ9JqBJ8YcO2SptR5LL3RK0Nv6GioriakB+8-Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Apr 12, 2013 at 10:20 PM, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> 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 from the defaults, we would have to know
> something about your server, or how you intend to use it. But you haven't
> told us any of those things. Is there something about your intended use of
> the server that made you wonder about this setting in particular?
>
> Anyway, wal seg size is one of the last things I would worry about
> changing. Also, I suspect non-default settings of that parameter get
> almost zero testing (either alpha, beta, or in the field), and so would
> consider it mildly dangerous to deploy to production.
>
> Cheers,
>
> Jeff
>

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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Rikard Pavelic 2013-04-13 18:08:16 Re: limit is sometimes not pushed in view with order
Previous Message Steve Singer 2013-04-13 16:14:10 Re: slow bitmap heap scans on pg 9.2