Обсуждение: jdbc connection process size

Hi All,

I hope this time somebody will answer my question here:

For each jdbc connection, postmaster starts a process that takes 10M.

Is there a way to tune this into a smaller size ??

What's the impact of reducing the process size ??

thanks,
kathy

How to check that ??

> To: Kathy Zhu <Kathy.Zhu@sun.com>
> Subject: Re: [GENERAL] jdbc connection process size
> From: Doug McNaught <doug@mcnaught.org>
> Date: 08 May 2003 17:42:29 -0400
> User-Agent: Gnus/5.0806 (Gnus v5.8.6) Emacs/20.7
>
> Kathy Zhu <Kathy.Zhu@Sun.COM> writes:
>
> > Hi All,
> >
> > I hope this time somebody will answer my question here:
> >
> > For each jdbc connection, postmaster starts a process that takes 10M.
>
> A lot of that (program text, shared buffers etc) is shared between
> backends.  What's the actual unshared space taken up by each backend?
>
> -Doug

Run top and look at the SIZE and SHARE settings.

If size is 10M and share is 9.9M, then no biggie, as the delta is only
0.1M

On Thu, 8 May 2003, Kathy Zhu wrote:

> How to check that ??
>
> > To: Kathy Zhu <Kathy.Zhu@sun.com>
> > Subject: Re: [GENERAL] jdbc connection process size
> > From: Doug McNaught <doug@mcnaught.org>
> > Date: 08 May 2003 17:42:29 -0400
> > User-Agent: Gnus/5.0806 (Gnus v5.8.6) Emacs/20.7
> >
> > Kathy Zhu <Kathy.Zhu@Sun.COM> writes:
> >
> > > Hi All,
> > >
> > > I hope this time somebody will answer my question here:
> > >
> > > For each jdbc connection, postmaster starts a process that takes 10M.
> >
> > A lot of that (program text, shared buffers etc) is shared between
> > backends.  What's the actual unshared space taken up by each backend?
> >
> > -Doug
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>