pgpool and DBD::Pg

--------------enigF3AD8F996C0290910778E140
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

hi,
My problem is as follows. I am using great DBI for connecting to
postgresql. My script, which connects to the database is run about 3-5
times per second. Last days we installed pgpool to check if it can speed
up some things. Unfortunatelly there is no difference between the script
connecting to pgpool and the script connectng to normal postgres. The
test were driven for 1000 executions of the script. For on php there a
huge speedup. Did somebody have similar experience ?



Dariusz Dwornikowski


--------------enigF3AD8F996C0290910778E140
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.1 (GNU/Linux)

iD8DBQFFo5Is1Zs59WqqS18RArBTAKCoTEszN2tx0OKvwTS1d9Aphr2nuwCf fuK6
0r485qL1Q7Til2NNSH0yom4=
=Y1B4
-----END PGP SIGNATURE-----

--------------enigF3AD8F996C0290910778E140--

peformance when running a script 3-5 times/second. (was: Re: pgpooland DBD::Pg)

Darek Dwornikowski wrote:
> hi,
> My problem is as follows. I am using great DBI for connecting to
> postgresql. My script, which connects to the database is run about 3-5
> times per second. Last days we installed pgpool to check if it can speed
> up some things. Unfortunatelly there is no difference between the script
> connecting to pgpool and the script connectng to normal postgres. The
> test were driven for 1000 executions of the script. For on php there a
> huge speedup. Did somebody have similar experience ?

It sounds like your issue would be solved by having a persistent
database connection, rather than connecting and re-connecting each time.

You didn't say whether you were running on the command line or on the web.

I would look at at a solution like PPerl (
http://search.cpan.org/dist/PPerl/PPerl.pm ),
FastCGI or mod_perl with Apache::DBI.

Once you have a persistent perl process, you can hold open the DB
handle, and pgpool shouldn't be required.

Good luck!

Mark