Postgres Pro
Downloads
Home   >   mailing lists

Re: Segment best size - Mailing list pgsql-performance

From Ben Chobot
Subject Re: Segment best size
Date
Msg-id 1767BAD3-8697-470E-95DD-5F9DB5150771@silentmedia.com
Whole thread Raw
In response to Segment best size  (Rodrigo Barboza <rodrigombufrj@gmail.com>)
Responses Re: Segment best size
List pgsql-performance
Tree view 
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.

pgsql-performance by date:

Previous
From: brick pglists
Date:
Subject: Changing ORDER BY column slows query dramatically
Next
From: Rodrigo Barboza
Date:
Subject: Re: Segment best size