Hi Matthew,
I was thinking of if that is the only option.
At this time, I can not make any changes to of the existing database objects. I can keep in mind for the future point of view.
Thank you.
Sarwar
From: Wetmore, Matthew (CTR) <Matthew.Wetmore@xxxxxxxxxxxxx>
Sent: Monday, April 8, 2024 9:30 AM To: M Sarwar <sarwarmd02@xxxxxxxxxxx>; Ron Johnson <ronljohnsonjr@xxxxxxxxx>; pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx> Subject: RE: How to tune SQL performance of function based columns of a view Make it a Materialized View with storage and you can index on a column. You can index a MV unlike a regular view.
From: M Sarwar <sarwarmd02@xxxxxxxxxxx>
Hi Ron,
I have analyzed and vacuumed following 2 tables which are used by the views.
TEK_INSPECTION_LIST_MCM TEST_PART_DETAILS_ALL_MCM_MID
I am still seeing unacceptable response time.
Is there any other way to tune a SQL which is referring a view?
Thanks, Sarwar
From: Ron Johnson <ronljohnsonjr@xxxxxxxxx>
Postgresql does auto-vacuum and auto-analyze, so the table might have been analyzed and vacuumed.
Table pg_stat_user_tables records the last time that user tables were vacuumed and analyzed.
On Sat, Apr 6, 2024 at 4:44 AM M Sarwar <sarwarmd02@xxxxxxxxxxx> wrote:
|