Re: [PATCHES] default resource limits

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Peter Eisentraut <peter_e(at)gmx(dot)net>
Subject: Re: [PATCHES] default resource limits
Date: 2005-12-24 17:18:45
Message-ID: 43AD82F5.3030700@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Robert Treat wrote:

>Maybe we should write something in to check if apache is installed if we're so
>concerned about that usage...
>

Er, yeah, I'll get right on that. (Don't hold your breath.)

>I already know that I set the connection limits
>lower on most of the installations I do (given than most installations are
>not production webservers).
>

So do I. In fact, even on production web servers I usually use
connection pooling and can rarely get an app to approach saturating a
pool size of around 20 let alone 100. But then you and I know something
about tuning Postgres. What I am aiming for is something that is closer
to the norm on out of the box configuration.

>There is also the argument to be made that just
>because systems these days have more memory doesn't mean we have to use it.
>
>
>

Just because we can run with very little memory doesn't mean we have to.
What is the point of having lots of memory if you don't use it? We are
talking defaults here. initdb will still scale down on resource-starved
machines.

cheers

andrew

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2005-12-24 20:20:18 Merry Christmas!
Previous Message Andrew Dunstan 2005-12-24 16:57:21 Re: [PATCHES] default resource limits

Browse pgsql-patches by date

  From Date Subject
Next Message Qingqing Zhou 2005-12-24 21:55:46 Improve XLOG_NO_TRAN related comments
Previous Message Andrew Dunstan 2005-12-24 16:57:21 Re: [PATCHES] default resource limits