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

Поиск
Список
Период
Сортировка
От Gary Fu
Тема Why DBI (DBD::Pg) takes so much memory ?
Дата
Msg-id i416md$2ea6$1@news.hub.org
обсуждение исходный текст
Ответы Re: Why DBI (DBD::Pg) takes so much memory ?  ("Greg Sabino Mullane" <greg@turnstep.com>)
Список pgsql-general
Hi,

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 ?

Thanks,
Gary

----- OS Version
$ cat /proc/version
Linux version 2.6.18-194.8.1.el5 (mockbuild@builder10.centos.org) (gcc
version 4.1.2 20080704 (Red Hat 4.1.2-48)) #1 SMP Thu Jul 1 19:04:48 EDT
2010

----- DBI & DBD::Pg versions
$ perl -e 'use DBI; print "$DBI::VERSION\n"'
1.607
2:46pm 675 sd3dev1@sd3dev1:~/tmp$ perl -e 'use DBD::Pg; print
"$DBD::Pg::VERSION\n"'
2.11.5

----- 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)
         libm.so.6 => /lib64/libm.so.6 (0x00002b8adefd9000)
         libc.so.6 => /lib64/libc.so.6 (0x00002b8adf25c000)
         libssl.so.6 => /lib64/libssl.so.6 (0x00002b8adf5b4000)
         libcrypto.so.6 => /lib64/libcrypto.so.6 (0x00002b8adf800000)
         libkrb5.so.3 => /usr/lib64/libkrb5.so.3 (0x00002b8adfb51000)
         libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00002b8adfde7000)
         libresolv.so.2 => /lib64/libresolv.so.2 (0x00002b8ae001f000)
         libnsl.so.1 => /lib64/libnsl.so.1 (0x00002b8ae0234000)
         libpthread.so.0 => /lib64/libpthread.so.0 (0x00002b8ae044d000)
         /lib64/ld-linux-x86-64.so.2 (0x00000039ffa00000)
         libgssapi_krb5.so.2 => /usr/lib64/libgssapi_krb5.so.2
(0x00002b8ae0668000)
         libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00002b8ae0896000)
         libk5crypto.so.3 => /usr/lib64/libk5crypto.so.3
(0x00002b8ae0a99000)
         libdl.so.2 => /lib64/libdl.so.2 (0x00002b8ae0cbe000)
         libz.so.1 => /usr/lib64/libz.so.1 (0x00002b8ae0ec2000)
         libkrb5support.so.0 => /usr/lib64/libkrb5support.so.0
(0x00002b8ae10d7000)
         libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00002b8ae12df000)
         libselinux.so.1 => /lib64/libselinux.so.1 (0x00002b8ae14e2000)
         libsepol.so.1 => /lib64/libsepol.so.1 (0x00002b8ae16fa000)


----- test program
#! /usr/local/bin/perl -w

use strict;
use DBI;

my $data_source = "dbi:Pg:dbname='dev1';host='db1'";
my $dbh = DBI->connect ($data_source, 'user', 'passwd')
     or die "Failed to connect";

sleep 600;
exit;

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: InitDB: Bad system call
Следующее
От: "Greg Sabino Mullane"
Дата:
Сообщение: Re: Why DBI (DBD::Pg) takes so much memory ?