On 12/03/16 03:46, Dilip Kumar wrote:

On Sat, Mar 12, 2016 at 5:31 AM, Jim Nasby <jim.na...@bluetreble.com
<mailto:jim.na...@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

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to