RE: Is PostgreSQL as an NT Service the next level?

>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
>postgres.exe processes.

I turned on connection pooling in the Data Source control panel for the
PostgreSQL driver. I'll see if that helps.

>Also, what kind of "vacuuming" do you do?  Just curious.

About once a day I open up a psql window and type "vacuum;" at the
prompt. Sometimes more often if the performance is slow. It does seem
to help but my performance is still very low.

Thanks,
Robby