On Mon, 2006-10-16 at 11:55 -0700, Junaili Lie wrote:
> Problem solved.
> although there's no old transaction in pg_stat_activity (no <IDLE> in
> transaction), I checked the pg_locks and found the transactionid =
> 746264948 (ev_minxid).
> So, I terminated the process associated with that transactionid, and a
> big chunk of sl_log_1 entries got deleted.
> :D
> I am not too sure if this is a bug related to slony or our
> application.
>  

Most likely your app.

-- 
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.