| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | Rodrigo Barboza <rodrigombufrj(at)gmail(dot)com> |
| Cc: | pgsql-performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Segment best size |
| Date: | 2013-04-13 01:20:38 |
| Message-ID: | CAMkU=1zLrowin5CK5YwxYZ+h_5z0BtbADO_SR2fbjqSTwxe8vg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Janes | 2013-04-13 01:20:39 | Re: slow bitmap heap scans on pg 9.2 |
| Previous Message | Scott Marlowe | 2013-04-12 23:06:15 | Re: [PERFORM] Recommended Swap space |