-----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@xxxxxxxxxxxx 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----- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
