postgres.exe processes

[anhtin]

I see many postgres.exe processes in the task manager. is this normal?
I am deverloping web map database postgresql but i see a problem, when i refresh my site, the number of postgres.exe processes still increases. my site is developing in local

Some body tell me is this normal ?

[Regina Obe]

Its not uncommon, but I guess it depends on what you mean by many.  I
think there are usually like 4 reserved for various system tasks so even
when your server is doing nothing, you probably have 4 going.  

Based on my limited understanding of how postgres works, its because it
is based on a multi-process architecture rather than a multi-threaded
architecture.

A lot of processes could signal that you are not properly closing your
connections in your web app.  You may also want to consider using
persistent connections in your web app if you can.

Now getting back to checking why you may have so many postgres processes
running.  Run the following query

SELECT * FROM
pg_stat_activity

and it will tell you what postgres processes are running and what they
are doing and what databases are doing.  I don't think this includes the
system processes though (at least not on Windows) so the number you see
in pg_stat_activity is the (actual number - 4)

Hope that helps,
Regina

 

-----Original Message-----
From: postgis-users-bounces@...
[mailto:postgis-users-bounces@...] On Behalf Of
anhtin
Sent: Tuesday, November 06, 2007 10:13 PM
To: postgis-users@...
Subject: [postgis-users] postgres.exe processes


I see many postgres.exe processes in the task manager. is this normal?
I am deverloping web map database postgresql but i see a problem, when i
refresh my site, the number of postgres.exe processes still increases.
my
site is developing in local

Some body tell me is this normal ?
--
View this message in context:
http://www.nabble.com/postgres.exe-processes-tf4762415.html#a13620598
Sent from the PostGIS - User mailing list archive at Nabble.com.

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users