LIKE CLAUSE on VIEWS

From: aditya desai <admad123(at)gmail(dot)com>
To: Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: LIKE CLAUSE on VIEWS
Date: 2023-01-22 11:33:46
Message-ID: CAN0SRDEHJUE79tS-=x19emW9tUd7F25Y-WCwsZD2taZdCpsEug@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Samed YILDIRIM 2023-01-22 11:40:58 Re: LIKE CLAUSE on VIEWS
Previous Message aditya desai 2023-01-22 11:29:14 Re: ALTER STATEMENT getting blocked