Re: need SQL logic to find out way's to Implement check sum to validate table data is migrated correctly

From: Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: need SQL logic to find out way's to Implement check sum to validate table data is migrated correctly
Date: 2023-10-27 09:34:02
Message-ID: 8789dad7-93b7-4a04-a061-668e8b1b3cc3@gelassene-pferde.biz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

Why do you need checksums? Can you not employ a full outer join? My
though behind this is that checksumming is quite costly cpuwise and you
have to fiddle with each and every relevent column, be it as part of the
checksum string be it as part of the joiner. The joiner would have the
advantage that you could, if you wanted, also implement logic to tell
you precisely in which columns the difference is encountered.

Kind regards

Thiemo

Am 27.10.2023 um 10:56 schrieb Y_esteembsv-forum:
> Hi
> Need SQL logic/different approach method's  to find out way's
> a) to Implement check sum to validate table data is migrated correctly
>
> Any guidance
>
> Regards
> Bharani SV

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2023-10-27 10:21:11 Re: need SQL logic to find out way's to Implement check sum to validate table data is migrated correctly
Previous Message Thomas Kellerer 2023-10-27 09:08:39 Re: Correct way of using complex expressions as partitioning key