[Bucardo-general] This doesn't look right...

[Joshua Tolley]

On Wed, Jun 30, 2010 at 10:58:27PM +0200, Michelle Sullivan wrote:
> Greg Sabino Mullane wrote:
> >> Type:                 pushdelta
> >> Source herd/database: sorbs2slave / usmaster
> >> Target database:      backup_server
> >> Tables in sync:       58
> >> Last good:            10m 45s (time to run: 20m 18s)
> >> Last good time:       Jun 27, 2010 17:37:29  Target: backup_server
> >> Ins/Upd/Del:          568676 / 0 / 2262
> >>     
> > ...
> >   
> >> Type:                 swap
> >> Source herd/database: sorbs2master / aumaster
> >> Target database:      usmaster
> >> Tables in sync:       58
> >> Last good:            1h 15m 43s (time to run: 29m 17s)
> >> Last good time:       Jun 27, 2010 16:32:39  Target: usmaster
> >> Ins/Upd/Del:          33183 / 171 / 0
> >>     
> > ...
> >   
> >> Note the insert counts...  how can the delta be more than the swap for
> >> inserts... it's all supposed to be in sync....
> >>     
> >
> > Hard to say from just this data. What is more disconcerting to me is 
> > the amount of time the syncs are taking - 20 minutes for half a 
> > million rows in a pushdelta sync indicates something wrong is 
> > going on. Do the logs indicate why things are taking so long?
> >   
> 
> Nothing - though I do see extended query times some times.. I have
> auto-explain on so lets see:

Could it be that bucardo_track and/or bucardo_delta are getting bloated?
It's often not a bad idea to vacuum them pretty aggresively.

-- 
Josh Tolley   josh at endpoint.com   801-987-0252
End Point Corporation  http://www.endpoint.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: Digital signature
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20100704/e9d0f291/attachment.bin