Re: Relation extension scalability

On 12/03/16 03:46, Dilip Kumar wrote:
>
> On Sat, Mar 12, 2016 at 5:31 AM, Jim Nasby <Jim.Nasby@bluetreble.com
> <mailto:Jim.Nasby@bluetreble.com>> wrote:
>
>     FWIW, this is definitely a real possibility in any shop that has
>     very high downtime costs and high transaction rates.
>
>     I also think some kind of clamp is a good idea. It's not that
>     uncommon to run max_connections significantly higher than 100, so
>     the extension could be way larger than 16MB. In those cases this
>     patch could actually make things far worse as everyone backs up
>     waiting on the OS to extend many MB when all you actually needed
>     were a couple dozen more pages.
>
>
> I agree, We can have some max limit on number of extra pages, What other
> thinks ?
>

Well, that's what I meant with clamping originally. I don't know what is 
a good value though.

--   Petr Jelinek                  http://www.2ndQuadrant.com/  PostgreSQL Development, 24x7 Support, Training &
Services