Postgres Pro
Downloads
Home   >   mailing lists

Re: Suggestion to improve query performance of data validation in proc. - Mailing list pgsql-general

From David G. Johnston
Subject Re: Suggestion to improve query performance of data validation in proc.
Date
Msg-id CAKFQuwYt35qF7U4neoGwZtPXmEqnLoo=J-Xo-Bafmm4M+3C_NA@mail.gmail.com
Whole thread Raw
Responses Re: Suggestion to improve query performance of data validation in proc.  (postgann2020 s <postgann2020@gmail.com>)
List pgsql-general
Tree view
You should read through the and the contained linked FAQ - note especially the concept and recommendation for “cross-posting”.

https://wiki.postgresql.org/wiki/Mailing_Lists#Email_etiquette_mechanics

On Thursday, May 21, 2020, postgann2020 s <postgann2020@gmail.com> wrote:

We have multiple long procs that are having 100s of data validations and currently we have written as below.

***********

if (SELECT 1  FROM SCHEMA.TABLE WHERE column=data AND column=data) then
statements
etc..

***********

Are there any other ways to validate the data, which will help us to improve the performance of the query?

I have no idea what your are trying to get at here.  You should try providing SQL that actually runs.  Though at first glance it seems quite probable your are doing useless work anyway.

David J.

pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Re: Query returns no rows in pg_basebackup cluster
Next
From: postgann2020 s
Date:
Subject: Re: Suggestion to improve query performance of data validation in proc.