From: Dave Dutcher <dave@tridecap.com>
To: 'Marcos' <mjs_ops@gmx.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORMANCE] Stored Procedures
Date: Mon, 23 Jan 2006 10:23:17 -0600
Message-ID: <000001c62039$579e88b0$8300a8c0@tridecap.com> (raw)
In-Reply-To: <1138022845.949.26.camel@servidor>
I don't think pgpool is what you need. If I understand pgpool
correctly, pgpool lets you pool multiple postgres servers together. You
are just looking for database connection pooling.
A simple connection pool is basically just an application wide list of
connections. When a client needs a connection, you just request a
connection from the pool. If there is an unused connection in the pool,
it is given to the client and removed from the unused pool. If there is
no unused connection in the pool, then a new connection is opened. When
the client is done with it, the client releases it back into the pool.
You can google for 'database connection pool' and you should find a
bunch of stuff. It's probably a good idea to find one already written.
If you write your own you have to make sure it can deal with things like
dead connections, synchronization, and maximum numbers of open
connections.
Dave
-----Original Message-----
From: pgsql-performance-owner@postgresql.org
[mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Marcos
Sent: Monday, January 23, 2006 7:27 AM
To: Markus Schaber
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] [PERFORMANCE] Stored Procedures
Hi Markus
> You really should consider using a connection pool (most web
application
> servers provide pooling facilities) or some other means to keep the
> connection between several http requests.
Yes. I'm finding a connection pool, I found the pgpool but yet don't
understand how it's work I'm go read more about him.
Thanks
Marcos
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dave@tridecap.com, mjs_ops@gmx.net
Subject: Re: [PERFORMANCE] Stored Procedures
In-Reply-To: <000001c62039$579e88b0$8300a8c0@tridecap.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox