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

[Michelle Sullivan]

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/