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

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

From
"Henshall, Stuart - WCP"
Date:
> >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