[Bucardo-general] Odd 'inconsistency' after one-time-copy

Michelle Sullivan 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
> 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

More information about the Bucardo-general mailing list