Josh Berkus wrote:

>Jan, Chris,
>
>Due to James Black's issue, we figured out that Slony won't purge anything 
>from s_log_1 which is younger than the oldest XID on the server.   
>
>What's the techincal reason for this?   The result is that orphaned 
>transactions cause a pretty fast buildup of s_log_1 rows.  Not that orphaned 
>transactions aren't a problem on their own, but we're wondering if this isn't 
>fixable in Slony *before* PostgreSQL gets an open_idle_transaction_timeout 
>setting.
>  
>
As you have probably seen, Darcy has a possible patch for this.

My question is whether we can get a good diagnosis of the cause of the 
situation.  It seems plausible that this might be something justifying a 
1.0.6 release, particularly if it is a condition people could fairly 
readily fall into by accident.

What was the "proximate cause"?  If we can document that, that's a good 
part of the battle all by itself.