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	May 22, 2020 11:09:40
Msg-id	CAKFQuwbcjxWdSQSThOy7Ofo2+8+nK5fGHMoBuciZxjS6RB9CVQ@mail.gmail.com Whole thread Raw
In response to	Re: Suggestion to improve query performance of data validation in proc. (postgann2020 s <postgann2020@gmail.com>)
Responses	Re: Suggestion to improve query performance of data validation in proc. (Michael Lewis <mlewis@entrata.com>)
List	pgsql-general

On Friday, May 22, 2020, postgann2020 s <postgann2020@gmail.com> wrote:

We are looking for a better query than "SELECT 1 FROM schema.table_name WHERE column1=structure_id1" this query for data validation.

There is no more simple a query that involve records on a single,table.

Please suggest is there any other ways to validate this kind of queries which will improve the overall performance.

Abandon procedural logic and embrace the declarative set oriented nature of SQL.

David J.

From: postgann2020 s
Date: 22 May 2020, 10:44:27
Subject: Re: Suggestion to improve query performance of data validation in proc.

From: Tim Kane
Date: 22 May 2020, 11:19:57
Subject: btree_gist extension - gbt_cash_union return type