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

From: "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk>
To: "'webmaster(at)robbyslaughter(dot)com'" <webmaster(at)robbyslaughter(dot)com>
Cc: Pgsql-Cygwin <pgsql-cygwin(at)postgresql(dot)org>
Subject: RE: Is PostgreSQL as an NT Service the next level?
Date: 2001-08-03 08:08:58
Message-ID: E2870D8CE1CCD311BAF50008C71EDE8E01F74656@MAIL_EXCHANGE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin


> >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

Browse pgsql-cygwin by date

  From Date Subject
Next Message Erwin van den Berg 2001-08-05 11:30:46 TCP-IP outside Cygwin?
Previous Message Robby Slaughter 2001-08-02 17:45:50 RE: Is PostgreSQL as an NT Service the next level?