Re: Why DBI (DBD::Pg) takes so much memory ?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160

> I have a simple perl program (see below) with DBI call to connect to the
> Postgresql db on a CentOS system. I don't know why the top command
> shows it takes more than 110m (under VIRT column). I tried with newer
> DBI and DBD versions still have the same result. However, I tried it on
> host with Mandriva, and it only takes about 8m. Is there any special on
> CentOS or some of the libraries are not linked or built correctly ?

> ----- libpq version
> $ ldd
> /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/Pg/Pg.so
> libpq.so.4 => /usr/lib64/libpq.so.4 (0x00002b8adedb7000)

That's probably your problem. libpq.so.5 came out with Postgres 8.2,
in 2006. See if you can get newer libraries, and the problem might
go away. Specifically, you need the postgresql-devel package.

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201008121237
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAkxkIzgACgkQvJuQZxSWSsgdeACguO4KtvoRIhWvTPcdqed+QKQ0
X+AAn16JOw6TRhtkB0TdMTfC6NkyNQac
=pUe4
-----END PGP SIGNATURE-----