Right; needs to be able to complete quickly, as VACUUM FULL will block writes, and hence transactions blocked by the trigger inserts.
> On Nov 3, 2018, at 7:01 PM, Michelle Sullivan <[email protected]> wrote: > > Check the delta table size... > > psql -U <a super user> <database> > Db=# SET SCHEMA bucardo; > Db=# SELECT COUNT(1) FROM bucardo.bucardo_<tablename>_delta; > > ... repeat for all <tablenames> in the sync, see how many changes there are... > > If a low number try VACUUM VERBOSE FULL ANALYZE > bucardo.bucardo_<tablename>_delta; for each table. > > Michelle Sullivan > http://www.mhix.org/ > Sent from my iPad > >> On 04 Nov 2018, at 05:27, Christophe Pettus <[email protected]> wrote: >> >> >> >>> On Nov 1, 2018, at 09:35, David Christensen <[email protected]> wrote: >>> >>> So this is the same on source/target? Anything happening in the “bucardo” >>> database? >> >> On the source database, all the Bucardo connections are in place, but idle; >> same on the bucardo database. >> >>> Is this multi-master or single master? >> >> Single master. >> >> Thanks! >> -- >> -- Christophe Pettus >> [email protected] >> >> _______________________________________________ >> Bucardo-general mailing list >> [email protected] >> https://mail.endcrypt.com/mailman/listinfo/bucardo-general -- David Christensen End Point Corporation [email protected] 785-727-1171 _______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
