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

[<as...@ko...>]

  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

-- 
 "Last year I was very tired."                                Adam Sjøgren
                                                         as...@ko...