Mitchell Perilstein wrote: > Are there actually rows missing if you do count(*) from db's on both > sides? > > I'm wondering if pg_database_size() is measuring allocated space, > including some padding rows perhaps. If there is nothing missing, > perhaps the copy might have populated the target db less randomly than > the source db was created, in which case a vacuum and/or reindex might > bring them into line? (/not a pgdba) >
You are correct, pg_database_size() includes deleted, and vacuum'd rows (and indexes iirc)... A count of the rows should be done on both sides to get an accurate result. -- Michelle Sullivan http://www.mhix.org/ _______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
