public inbox for [email protected]
help / color / mirror / Atom feedFrom: Halley Pacheco de Oliveira <[email protected]>
To: [email protected]
Cc: Alvaro Herrera <[email protected]>
Cc: Roman Neuhauser <[email protected]>
Subject: Re: PostgreSQL 8.0.3 Documentation - Chapter 23. Monitoring Database Activity
Date: Wed, 27 Jul 2005 09:35:09 -0300 (ART)
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
--- Alvaro Herrera <[email protected]> escreveu:
>
> Hmm, seems a very similar thing can be had in Postgres by means of
> pgpool.
>
You're right. Using a JDBC connection pool to cache database connections, reuse physical
connections and minimize expensive operations in the creation and closing of database sessions
(1), or pgpool that is a connection pool server for PostgreSQL (2), the overhead of create a
server process for each new connection almost disappears.
It will only be necessary one connection pool for each database accessed, and pgpool will make a
new connection if there's no user name and database name pair yet.
Once more the middle tier simplifies the database operation.
Regards,
Halley
(1)
http://www.oracle.com/technology/sample_code/tech/java/sqlj_jdbc/files/9i_jdbc/OCIMidAuthSample/Read...
(2) http://pgpool.projects.postgresql.org/
__________________________________________________
Converse com seus amigos em tempo real com o Yahoo! Messenger
http://br.download.yahoo.com/messenger/
view thread (11+ messages)
reply
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: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: PostgreSQL 8.0.3 Documentation - Chapter 23. Monitoring Database Activity
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox