Postgres Pro
Downloads
Home   >   mailing lists

Re: Segment best size - Mailing list pgsql-performance

From Rodrigo Barboza
Subject Re: Segment best size
Date
Msg-id CANs8QJaOp+mt+NH0t-VFmbVx1AB3jS1VMziCpoA=ZNm=NqWj5A@mail.gmail.com
Whole thread Raw
In response to Re: Segment best size  (Ben Chobot <bench@silentmedia.com>)
List pgsql-performance
Tree view



On Fri, Apr 12, 2013 at 2:52 PM, Ben Chobot <bench@silentmedia.com> 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 in the configuration file, the compiled-in defaults work well for most people.

Thanks!

pgsql-performance by date:

Previous
From: Ben Chobot
Date:
Subject: Re: Segment best size
Next
From: Shaun Thomas
Date:
Subject: Re: Changing ORDER BY column slows query dramatically