----- Original Message -----
From: "Robby Slaughter" <webmaster(at)robbyslaughter(dot)com>
Cc: "Pgsql-Cygwin" <pgsql-cygwin(at)postgresql(dot)org>
Sent: Wednesday, August 01, 2001 3:41 PM
Subject: [CYGWIN] Is PostgreSQL as an NT Service the next level?
> Cygwin folks: It does work---I can execute queries against it and
> am even using some PG/plSQL stored procedures. But it gets slow,
> even with regular vacumming, and more importantly, after a while
> literally dozens of "postgresql.exe" processes appear in the
> Task Manager, bogging down the system until I have to kill all
> the processes and restart the database.
As I understand it, there is postgres.exe process per connection. Perhaps
you could reduce the dozens of of processes by doing some connection
pooling. I'm using postgresql as the db for a J2EE app on 2000. My J2EE
platform does connection pooling for me and I never get more than 4
Also, what kind of "vacuuming" do you do? Just curious.
In response to
pgsql-cygwin by date
|Next:||From: Robby Slaughter||Date: 2001-08-02 17:45:50|
|Subject: RE: Is PostgreSQL as an NT Service the next level?|
|Previous:||From: Robby Slaughter||Date: 2001-08-01 21:41:50|
|Subject: Is PostgreSQL as an NT Service the next level?|