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@gmail.com>
Sent: Saturday, April 6, 2024 9:58 AM
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: How to tune SQL performance of function based columns of a view
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.
This is Pg 13.
It is running on Aws / Rds.
I am not doing any Vacuum/ Analyze manually.
Thanks,
Sarwar
Sent from my Galaxy
-------- Original message --------
Date: 4/6/24 1:15 AM (GMT-05:00)
Subject: Re: How to tune SQL performance of function based columns of a view
Hello,
I am working on SQL performance issue.
1. What PG version?
2. When did you last VACUUM and ANALYZE the base tables?