Re: [NOVICE] General Performance questions

From: Lonni J Friedman <lfriedman(at)vasoftware(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Delao, Darryl W" <ddelao(at)ou(dot)edu>, "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>, "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: [NOVICE] General Performance questions
Date: 2003-03-10 20:16:58
Message-ID: Pine.LNX.4.44.0303101215580.8716-100000@beefcake.hdqt.vasoftware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

On Mon, 10 Mar 2003, Tom Lane wrote:
> "Delao, Darryl W" <ddelao(at)ou(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Diego Gil 2003-03-10 20:18:02 Ncurses / Console example
Previous Message Tom Lane 2003-03-10 20:10:55 Re: [NOVICE] General Performance questions

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-03-10 20:33:28 Re: [NOVICE] General Performance questions
Previous Message Tom Lane 2003-03-10 20:10:55 Re: [NOVICE] General Performance questions