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

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: Why DBI (DBD::Pg) takes so much memory ?
Дата
Msg-id df85cb95c0553296d4d7485d96e705bd@biglumber.com
обсуждение исходный текст
Ответ на Why DBI (DBD::Pg) takes so much memory ?  (Gary Fu <gary.fu@sigmaspace.com>)
Список 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 по дате отправления:

Предыдущее
От: Gary Fu
Дата:
Сообщение: Why DBI (DBD::Pg) takes so much memory ?
Следующее
От: Alban Hertroys
Дата:
Сообщение: Re: InitDB: Bad system call