> >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
>
>
Maybe VACUUM ANALYSE to update statistics would be better.
- Stuart
