Home > mailing lists

Segment best size - Mailing list pgsql-performance

From	Rodrigo Barboza
Subject	Segment best size
Date	April 12, 2013 19:45:37
Msg-id	CANs8QJZ82gA7iwEnErXQXM6XXTjidZBGLmoN+PqWxA-TTB1K_A@mail.gmail.com Whole thread Raw
Responses	Re: Segment best size Re: Segment best size
List	pgsql-performance

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?

From: Richard Huxton
Date: 12 April 2013, 13:02:13
Subject: Re: PsqL8.3

From: brick pglists
Date: 12 April 2013, 19:51:11
Subject: Changing ORDER BY column slows query dramatically