On Jan 15, 2009, at 10:20 AM, Bill Moran wrote:
I don't believe that's true. My understanding of pgpool is that it
will
reuse an existing connection if it's free, or open a new one if
required.
Gah! It just made it worse!
$ ps auxwww | grep pgpool | grep dbuser | wc -l
30
$ ps auxwww | grep postgres: | grep dbuser | wc -l
38
So not only is it not sharing connections among clients, but it's
keeping old ones open too. This isn't really what I had in mind.
Also, many of the applications are launched in the morning and open a
connection, then get used all day, then closed at the end of the
afternoon. I'm starting to wonder if perhaps pgpool-II isn't what I
was looking for.
--
Kirk Strauser
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
