pgdatadiff icon indicating copy to clipboard operation
pgdatadiff copied to clipboard

[CONSISTENCY] The sum of numeric column values in the database are compared for consistency of data.

Open unalsurmeli opened this issue 4 years ago • 5 comments

unalsurmeli avatar Feb 13 '21 23:02 unalsurmeli

Gimme an idea of what this actually does?

(I mean, compared to the md5 approach)

dmarkey avatar Feb 13 '21 23:02 dmarkey

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

unalsurmeli avatar Feb 14 '21 00:02 unalsurmeli

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.

unalsurmeli avatar Feb 17 '21 11:02 unalsurmeli

It's faster but much less accurate, correct?

dmarkey avatar Feb 20 '21 23:02 dmarkey

It's faster but much less accurate, correct?

Yes, absolutely.

unalsurmeli avatar Feb 24 '21 10:02 unalsurmeli