From: | Greg Copeland <greg(at)CopelandConsulting(dot)Net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, PostgresSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Changing the default configuration (was Re: |
Date: | 2003-02-11 19:16:15 |
Message-ID: | 1044990974.2501.207.camel@mouse.copelandconsulting.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-hackers pgsql-performance |
On Tue, 2003-02-11 at 12:55, Tom Lane wrote:
> "scott.marlowe" <scott(dot)marlowe(at)ihs(dot)com> writes:
> > Is setting the max connections to something like 200 reasonable, or likely
> > to cause too many problems?
>
> That would likely run into number-of-semaphores limitations (SEMMNI,
> SEMMNS). We do not seem to have as good documentation about changing
> that as we do about changing the SHMMAX setting, so I'm not sure I want
> to buy into the "it's okay to expect people to fix this before they can
> start Postgres the first time" argument here.
>
> Also, max-connections doesn't silently skew your testing: if you need
> to raise it, you *will* know it.
>
Besides, I'm not sure that it makes sense to let other product needs
dictate the default configurations for this one. It would be one thing
if the vast majority of people only used PostgreSQL with Apache. I know
I'm using it in environments in which no way relate to the web. I'm
thinking I'm not alone.
Regards,
--
Greg Copeland <greg(at)copelandconsulting(dot)net>
Copeland Computer Consulting
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Hoffmann | 2003-02-11 19:36:05 | Re: Changing the default configuration (was Re: [pgsql-advocacy] |
Previous Message | Tom Lane | 2003-02-11 19:06:32 | Re: Changing the default configuration (was Re: [pgsql-advocacy] PostgreSQL Benchmarks) |
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Copeland | 2003-02-11 19:23:17 | Re: Windows SHMMAX (was: Default configuration) |
Previous Message | mlw | 2003-02-11 19:10:34 | Re: location of the configuration files |
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Hoffmann | 2003-02-11 19:36:05 | Re: Changing the default configuration (was Re: [pgsql-advocacy] |
Previous Message | Tom Lane | 2003-02-11 19:06:32 | Re: Changing the default configuration (was Re: [pgsql-advocacy] PostgreSQL Benchmarks) |