pgdatadiff
pgdatadiff copied to clipboard
[CONSISTENCY] The sum of numeric column values in the database are compared for consistency of data.
Gimme an idea of what this actually does?
(I mean, compared to the md5 approach)
Gimme an idea of what this actually does?
(I mean, compared to the md5 approach)
Actually, the goal here is really to verify that data is consistent. For example, the row numbers of a table may be equal, but the price column values may not be equal. I want to confirm that. @dmarkey
Gimme an idea of what this actually does?
(I mean, compared to the md5 approach)
@dmarkey I get what you mean in the MD5 part, MD5 is more accurate, but it takes days in a database with millions of records. So getting the sum of the columns results faster.
It's faster but much less accurate, correct?
It's faster but much less accurate, correct?
Yes, absolutely.