Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qwJxt-00B591-SG for pgsql-general@arkaria.postgresql.org; Fri, 27 Oct 2023 10:21:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qwJxr-00EOIq-Nx for pgsql-general@arkaria.postgresql.org; Fri, 27 Oct 2023 10:21:15 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qwJxr-00EOIi-D9 for pgsql-general@lists.postgresql.org; Fri, 27 Oct 2023 10:21:15 +0000 Received: from mail-oi1-x229.google.com ([2607:f8b0:4864:20::229]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qwJxo-002YQN-Sc for pgsql-general@lists.postgresql.org; Fri, 27 Oct 2023 10:21:14 +0000 Received: by mail-oi1-x229.google.com with SMTP id 5614622812f47-3b3f6dd612cso1148906b6e.3 for ; Fri, 27 Oct 2023 03:21:12 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1698402072; x=1699006872; darn=lists.postgresql.org; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=1yn/VgAAYtj07M+t51NgcQQwJIZAAhEUPnMfbVcQ3SU=; b=bMYhc4g9eiHrxPTaRJ1wtaQUE5kDvpiQQ1trVt3UCSoyEw6Qskq7DMJBY67418mxIC LYBmq7lWcC09YyTf381xNn83g0ZwTzzrQ+5zoZyV9cUCdq0jQOHFV9oLp2zT/ttansK0 RsiGrtj/LRptnT5VMhEnuFe6bunTjLxMISygOcGjX/ZBLSADuGBnI6yDDJ7XA/EyDQ4W Sj9fHJRTS+7d4wX+rqLQlsEXwLCYnTCMC+G3X0VC49dPgCPoAcw4zahzMcrE5HkLnAAn rT4f4wpbL7sTBxYMd0/NSJ35ph6zaUEa8O5WqDCUdxQvL7iDhmcLXFAgs7a6c5DqacnQ 9oPA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1698402072; x=1699006872; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=1yn/VgAAYtj07M+t51NgcQQwJIZAAhEUPnMfbVcQ3SU=; b=rtk3bwFrZ2ykhv/1I+KuUuwCoJ24EN4/7PZAEBdTmiU3syQiNxc8WY0b3h7dT9XiaN cZ9aPYkLKTlMt637OMY9crnfNVEb/hP6FprMXf6VsYiS54MYuQWjb8U8JVmEgjyxzmL0 GCd+swWU+6NBcBXNpoWwlE2D3UNYeruisJnUD6A0qzuyIBcEoCrLTXsAoIKRnESIgxua vd99AYk1Ej6IgzBFlqtGhgYHH0v/SeYE+q/3FkuZVICl8RPtATmUVITjhriyzQTN0obH 1kIqr/MjcW17uDVLEHCns9ufwIxefXCRyBvP5yxy7Qr4VMR8+Te8rvyoDDHdBeNn1L+h X36A== X-Gm-Message-State: AOJu0YyEuJ+Yha0kYp9fM80X6pbqhyPA3XPi1I0PbSswEI+d0WNLrrWT 98ew3d5L5Eii1SbBvV8WH114+im349E= X-Google-Smtp-Source: AGHT+IGNRKTGzHW80RT7TVHnDDKLDko1y3RZKPjC1ZyHmpxpJSmaW2l+3Em381QM3BfGwro72LrAOg== X-Received: by 2002:a05:6808:20d:b0:3ae:5bf5:4ad1 with SMTP id l13-20020a056808020d00b003ae5bf54ad1mr1997022oie.33.1698402071913; Fri, 27 Oct 2023 03:21:11 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:e0e7:f6ad:239e:5da2? ([2600:1700:bd2c:b810:e0e7:f6ad:239e:5da2]) by smtp.googlemail.com with ESMTPSA id b206-20020a2534d7000000b00d9caecd5c86sm543767yba.62.2023.10.27.03.21.11 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 27 Oct 2023 03:21:11 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------jiCfphT19OP8BZFhHOhQSvNL" Message-ID: <14a36dc0-8796-49f4-bf37-535bfe3f0b74@gmail.com> Date: Fri, 27 Oct 2023 05:21:11 -0500 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: need SQL logic to find out way's to Implement check sum to validate table data is migrated correctly Content-Language: en-US To: pgsql-general@lists.postgresql.org References: <1334708887.12132.1698396967548.ref@mail.yahoo.com> <1334708887.12132.1698396967548@mail.yahoo.com> <8789dad7-93b7-4a04-a061-668e8b1b3cc3@gelassene-pferde.biz> From: Ron In-Reply-To: <8789dad7-93b7-4a04-a061-668e8b1b3cc3@gelassene-pferde.biz> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------jiCfphT19OP8BZFhHOhQSvNL Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit OP might be referring to migrating from, say, Oracle to Postgresql when oracle_fdw is not available. On 10/27/23 04:34, Thiemo Kellner wrote: > > 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 -- Born in Arizona, moved to Babylonia. --------------jiCfphT19OP8BZFhHOhQSvNL Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit
OP might be referring to migrating from, say, Oracle to Postgresql when oracle_fdw is not available.

On 10/27/23 04:34, Thiemo Kellner wrote:

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

--
Born in Arizona, moved to Babylonia.
--------------jiCfphT19OP8BZFhHOhQSvNL--