| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | postgann2020 s <postgann2020(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Subject: | Re: Suggestion to improve query performance of data validation in proc. |
| Date: | 2020-05-22 07:06:05 |
| Message-ID: | CAKFQuwYt35qF7U4neoGwZtPXmEqnLoo=J-Xo-Bafmm4M+3C_NA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general pgsql-performance |
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(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2020-05-22 07:14:57 | Re: Suggestion to improve query performance for GIS query. |
| Previous Message | postgann2020 s | 2020-05-22 06:59:16 | Suggestion to improve query performance for GIS query. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | postgann2020 s | 2020-05-22 07:44:27 | Re: Suggestion to improve query performance of data validation in proc. |
| Previous Message | Andrus | 2020-05-22 06:53:37 | Re: Query returns no rows in pg_basebackup cluster |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2020-05-22 07:14:57 | Re: Suggestion to improve query performance for GIS query. |
| Previous Message | postgann2020 s | 2020-05-22 06:59:16 | Suggestion to improve query performance for GIS query. |