Postgres Pro
Downloads
Home   >   mailing lists

LIKE CLAUSE on VIEWS - Mailing list pgsql-performance

From aditya desai
Subject LIKE CLAUSE on VIEWS
Date
Msg-id CAN0SRDEHJUE79tS-=x19emW9tUd7F25Y-WCwsZD2taZdCpsEug@mail.gmail.com
Whole thread Raw
Responses Re: LIKE CLAUSE on VIEWS  (Samed YILDIRIM <samed@reddoc.net>)
Re: LIKE CLAUSE on VIEWS  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-performance
Tree view
Hi,
Is there any way to improve performance of LIKE clause on VIEWS.

select * From request_vw where upper(status) like '%CAPTURED%' - 28 seconds.

select * from  request_vw where status='CAPTURED'

Application team is reluctant to change queries from the Application side to = instead of LIKE.

Also as this is VIEW TRIGRAM nor normal indexes don't get used.


Regards,
Aditya.

pgsql-performance by date:

Previous
From: aditya desai
Date:
Subject: Re: ALTER STATEMENT getting blocked
Next
From: Samed YILDIRIM
Date:
Subject: Re: LIKE CLAUSE on VIEWS