[Sqlgrey-users] sqlgrey+postgresql using more and more memory

[Adam Sjøgren]

Hi.


I have been running sqlgrey for a long time on my little home-server -
with great success; it is wonderful.

Recently I have noticed an annoying increase in memory usage; for
instance, right now:

$ ps aux | grep [s]qlgrey
sqlgrey 26080 0.0 6.6 168832 133220 ? Ss Jun27 0:32 /usr/bin/perl -w /usr/sbin/sqlgrey --daemonize
postgres 26113 0.0 17.1 403472 342368 ? S Jun27 0:37 postgres: sqlgrey sqlgrey 127.0.0.1(33636) idle

The "only" two changes I have done recently, that I can think of, is
upgrading to Debian 4.0 (etch) and migrating to an amd64 machine.

The versions I am running are:

$ /usr/sbin/sqlgrey --version
sqlgrey 1.6.7
$ dpkg -l postgresql-8.1 | grep ^ii
ii postgresql-8.1 8.1.9-0etch1 object-relational SQL database, version 8.1 server
$ perl -MDBI -e 'print $DBI::VERSION . "\n"'
1.53
$ perl -MDBD::Pg -e 'print $DBD::Pg::VERSION . "\n"'
1.49
$ perl -MNet::Server::Multiplex -e 'print $Net::Server::Multiplex::VERSION . "\n"'
0.94
$

The amount of data in my database is far from overwhelming: 3441 rows in
connect, 1497 in from_awl and 47 in domain_awl.

A couple of months ago there was a thread about Gentoo/sqlgrey/mysql
where the advice was to try different versions of DBI and the DBD
driver.

I was wondering if anyone is running the same versions as I do
with/without problems?

I think it would be cool to find the culprit, but before I spend a lot
of time trying to track it down, it would be nice to hear if there are
other people using the same combination.

A quick run through DBI::Changes (1.54-1.58) and Changes for
Net::Server::Multiplex (0.95-0.96) did not yield anything immediately
obvious, to me.


Best regards,

Adam