[rt-users] RT session cleanup - session table size

Craig Ringer craig at 2ndquadrant.com
Tue Jul 9 03:23:53 EDT 2013


On 07/09/2013 03:05 PM, Alex Decalli wrote:
> I think there is no such table.

There certainly is. From my PostgreSQL logs on the database that RT is
using:

    UPDATE sessions SET a_session = $1 WHERE id = $2

with a giant binary blob as $1"

    DETAIL:  parameters: $1 = 'BQgDAAAACQQRD1

RT should really be using DBD::Pg's native bytea support on PostgreSQL,
not base64-encoding binary for storing in the database, btw, something like:

  $rv = $sth->bind_param($param_num, $bind_value,
                         { pg_type => DBD::Pg::PG_BYTEA });

per http://search.cpan.org/~rudy/DBD-Pg/Pg.pm


-- 
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services



More information about the rt-users mailing list