| From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
|---|---|
| To: | Ashish Karalkar <ashish_karalkar(at)yahoo(dot)com> |
| Cc: | slony <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL Connections? |
| Date: | 2007-01-10 23:14:53 |
| Message-ID: | 1168470893.2411.4.camel@dogma.v10.wvs |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 2007-01-09 at 21:48 -0800, Ashish Karalkar wrote:
> Hello All,
> I am running PostgresSQL 8.2 on Redhat Linux 4.
> When I look for the processes that are using postgres
> using ps aux|more
> I got lots of Idle processes with servers own IP
> address. Can anybody please tell me why this is
> happening.
>
> Also there are multiple processes for my single
> client(same IP) of which maximum are idle. are these
> processes means connection or there is a single
> connection starting many processes.
>
You probably have clients accessing postgresql and holding the
connection open, perhaps in a connection pool. Do you have web
applications accessing the database?
Regards,
Jeff Davis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Casey Duncan | 2007-01-10 23:15:41 | Re: replication advice needed |
| Previous Message | Chad Wagner | 2007-01-10 23:11:51 | Re: How does one perform a case-insenstive query on test or char fields |