[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