[postgis-users] Multiple instances of postgres.exe, Geoserver hangs

[Markus Schaber]

Hi, Paul,
Hi, GPS Blaster,

Paul Ramsey wrote:
> That's the way PostgreSQL works, one process per connection, with shared
> memory segment for interprocess communications, plus one master process
> to create child processes as new connections come in.

Depending on the PostgreSQL version and configuration, there are also
some utility processes like the autovacuum daemon, the background writer
and the statistics collector.

PostgreSQL is optimized for long-living connections, wich can handle
millions of transactions / user requests before being closed again.

The maximum number of backend processes is set in the PostgreSQL
configuration file.

I don't know much about Geoserver, but maybe you can reconfigure it to
use persistent connections, or use a pgpool instance inbetween.

HTH,
Markus
-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org