[GENERAL] Followup: Here's why I want to use connection pooling middleware!

On Thursday 15 January 2009 09:54:50 Kirk Strauser wrote: > I have a PostgreSQL 8.3.5 server with max_connections = 400. At this > moment, I have 223 open connections, including 64 from a bunch of > webserver processes and about 100 from desktop machines running a > particular appli

Re: [GENERAL] Why would I want to use connection pooling middleware?

I've never really gone far into low- level optimizations like this. -- 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

Re: [GENERAL] Why would I want to use connection pooling middleware?

t least see what the excitingment is about. -- 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

Re: [GENERAL] Why would I want to use connection pooling middleware?

ny given time. The database itself is currently hosted on a dual Xeon server with 3GB of RAM and other applications so I'm sure the new 8-core/8GB hardware is bound to do better at any rate. -- Kirk Strauser -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

Re: [GENERAL] Why would I want to use connection pooling middleware?

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

Re: [GENERAL] Why would I want to use connection pooling middleware?

to have a flag for "enable_pooling". Is "num_init_children" effectively the same as a hypothetical "max_children?" If I set it to "1" and leave "max_pool" at "4", then clients queue up while one at a time gets to connect. Sorry, I know this

[GENERAL] Why would I want to use connection pooling middleware?

e she waits for it to finish. Is that true? Even if not, what would be the advantage in the two of them sharing a connection? I'm just trying to wrap my head around this. Thanks! -- Kirk Strauser -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make chang

Re: [GENERAL] FreeBSD and large shared_buffers a no-go?

On Jan 7, 2009, at 12:30 PM, Tom Lane wrote: Kirk Strauser writes: First, shmget is asking for a lot less than shmmax - why is it failing? Check to see if things work as expected when you have shmmax and shmall set to a shade less than 2GB and fail when they are a shade more. If so, it

Re: [GENERAL] FreeBSD and large shared_buffers a no-go?

On Jan 7, 2009, at 12:30 PM, Tom Lane wrote: Kirk Strauser writes: First, shmget is asking for a lot less than shmmax - why is it failing? Check to see if things work as expected when you have shmmax and shmall set to a shade less than 2GB and fail when they are a shade more. If so, it

[GENERAL] FreeBSD and large shared_buffers a no-go?

ration. First, shmget is asking for a lot less than shmmax - why is it failing? Second, does the "one fourth of RAM" rule of thumb still apply on systems with decent amounts of memory? Third, is there anything else I can be doing to take advantage of this RAM and 8 CPU cores? Thanks! -- Kirk Strauser

Re: [GENERAL] PostgreSQL vs FreeBSD 7.0 as regular user

On Friday 25 July 2008, Zoltan Boszormenyi wrote: > is there anyone using PostgreSQL on FreeBSD 7.0 starting from scratch? Every day. > I compiled 8.3.3 and wanted to run initdb in my home directory but > it fails with the error below. How did you install PostgreSQL? -- Kirk Straus

[GENERAL] PgDBF, Another XBase to PostgreSQL converter

how this turned out. -- 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

[GENERAL] Re: A903-35A9-76AF : CONFIRM from pgsql-general (subscribe)

accept A903-35A9-76AF ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]