[Bucardo-general] Performance issues... (4.5.x)

Greg Sabino Mullane greg at endpoint.com
Wed May 8 14:53:09 UTC 2013

On Sat, May 04, 2013 at 05:30:46PM +0200, Michelle Sullivan wrote:
> So perhaps put it in the bucardo_purge_delta() function?  Seems you can
> continually vacuum full it with no ill effects or slowdown or locking
> issues so doing it every 15 minutes will un-noticable... and every day
> wouldn't be an issue either...

I would prefer to keep it separate from that function. For one thing, I'd 
need to rename it to keep things honest! :) I think we'll simply have the 
MCP/VAC call bucardo_purge_delta on each database, then do a second round to 
vacuum pg_listener on any databases that need it. Keeping it separate will 
also allow us to vacuum more or less often than purge_delta, should we need 
to in the future.

Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: Digital signature
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20130508/1992497a/attachment.sig>

More information about the Bucardo-general mailing list