Re: [NOVICE] General Performance questions - Mailing list pgsql-general

From Lonni J Friedman
Subject Re: [NOVICE] General Performance questions
Date
Msg-id Pine.LNX.4.44.0303101215580.8716-100000@beefcake.hdqt.vasoftware.com
Whole thread Raw
In response to Re: [NOVICE] General Performance questions  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [NOVICE] General Performance questions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Mon, 10 Mar 2003, Tom Lane wrote:
> "Delao, Darryl W" <ddelao@ou.edu> writes:
> > Im looking at netstat on my db server and I see a few postgres connections.
> > I have heard that each of these connections actually represents 16
> > connections to postgres.  Can anyone confirm this?
>
> Where did you hear that?  It's nonsense.

Well, it was over a year ago.  basically what happened was that whenever i
set the value to be anything greater than 32, postmaster failed to start.
bring it back down to a value less than or equal to 32, and it started up
fine.  after recompiling postgresql with a hardcoded value of 64, then i
was able to increase it in postgresql.conf.


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Lonni J Friedman                877-VALINUX x77159
Technical Support                 VA Software


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [NOVICE] General Performance questions
Next
From: Tom Lane
Date:
Subject: Re: Problems with pg_dump