Needs todo it on the delta and track tables as I have seen table bloat slow the delta join slow to ridiculously long queries... the full will remove the bloat that a normal vacuum won’t.
Michelle Sullivan http://www.mhix.org/ Sent from my iPad > On 05 Nov 2018, at 02:29, David Christensen <[email protected]> wrote: > > 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
