----- Original Message -----

> From: Steve Singer <ssinger at ca.afilias.info>
> To: slony1-general at lists.slony.info
> Cc: 
> Sent: Monday, 2 February 2015, 14:41
> Subject: Re: [Slony1-general] Slony 2.2.3 extended lag recovery
> 
> On 01/29/2015 12:01 PM, Glyn Astill wrote:
> 
> 
> Why are you regularly running vacuum full (versus normal vaccum?)

> 

We're not regularly running vacuum full, I didn't state that.

> Vacuum full will take an exclusive lock on the table for its duration. 
> Also the cluster command tends to be faster than vacuum full but with 
> similar results (re-writing your tables)
> 
> Are you running vacuum full on specific tables or on all tables in your 
> cluster?

> 

Understood.

Just the one, just the once, I only mentioned it because it was the thing that caused the lag build up - and the lag was expected, no ignorance there.


However we've had similar long running backlogs since moving to 2.2 and we're definatey not ever running vacuum full at any other time.

> If you do a vacuum full on a table on your replica slony won't be able 
> to insert any data into that table until the vacuum transaction is 
> complete and the exclusive lock is released.
> 
> 


Understood.  My point is that we seem to be seeing lag recovery taking longer than expected since slony switched to using copy vs regular insert/update/delete.