Re: Why DBI (DBD::Pg) takes so much memory ? - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Why DBI (DBD::Pg) takes so much memory ?
Date
Msg-id df85cb95c0553296d4d7485d96e705bd@biglumber.com
Whole thread Raw
In response to Why DBI (DBD::Pg) takes so much memory ?  (Gary Fu <gary.fu@sigmaspace.com>)
List pgsql-general
-----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@turnstep.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-----



pgsql-general by date:

Previous
From: Gary Fu
Date:
Subject: Why DBI (DBD::Pg) takes so much memory ?
Next
From: Alban Hertroys
Date:
Subject: Re: InitDB: Bad system call