Jan Wieck wrote:
> That sounds very much like pg_listener bloat.
> 
> I guess you where not running pg_autovacuum, nor did any other regular 
> vacuum maintenance on the two database.

Actually, pg_autovacuum was definitely running.  (Checked and verified, 
pg_listener is even in the logging for the pg_autovacuum daemon).


 > The latest versions in CVS, HEAD
> as well as REL_1_0_STABLE, have pg_listener added to the tables 
> frequently vacuumed by slon.

Cool.  When 1.0.3 is released I'll try it again with the 100ms sync delay.


> Please issue a "vacuum full pg_listener" on both nodes and see if that 
> gets things back to normal.

It's kind of a non-issue now.  A 1 second sync delay seems to be working 
fine (pg_autovacuum is on too).

:)

Regards and best wishes,

Justin Clift


> Jan