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 ??
Show quoted text
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.7Kathy 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
Import Notes
Resolved by subject fallback
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:
Show quoted text
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.7Kathy 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