| From: | postgann2020 s <postgann2020(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org>, pgsql-general <pgsql-general(at)postgresql(dot)org>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, PostgreSQL mailing lists <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Suggestion to improve query performance of data validation in proc. |
| Date: | 2020-05-22 06:41:10 |
| Message-ID: | CANynezPm5t35FEiCV7zukXd+N_u4LPDVU0E7fzn0hKZ6CeOoQg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general pgsql-performance |
Hi Team,
Thanks for your support.
Could you please suggest on below query.
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?.
Thanks for your support.
Regards,
PostgAnn.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | postgann2020 s | 2020-05-22 06:59:16 | Suggestion to improve query performance for GIS query. |
| Previous Message | Raj kumar | 2020-05-22 04:36:08 | Lag clarification with Sync Replication |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrus | 2020-05-22 06:53:37 | Re: Query returns no rows in pg_basebackup cluster |
| Previous Message | Andrus | 2020-05-22 06:15:39 | Re: Query returns no rows in pg_basebackup cluster |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | postgann2020 s | 2020-05-22 06:59:16 | Suggestion to improve query performance for GIS query. |
| Previous Message | postgann2020 s | 2020-05-21 14:53:18 | Re: Suggestion on index creation for TEXT data field |