[Bucardo-general] Odd 'inconsistency' after one-time-copy
michelle at sorbs.net
Tue Jul 23 21:46:35 UTC 2013
Mitchell Perilstein wrote:
> Are there actually rows missing if you do count(*) from db's on both
> 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.
More information about the Bucardo-general