Re: How to tune SQL performance of function based columns of a view

[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>
Sent: Saturday, April 6, 2024 9:58 AM
To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
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.

On Sat, Apr 6, 2024 at 4:44 AM M Sarwar <sarwarmd02@xxxxxxxxxxx> wrote:

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 --------

From: Ron Johnson <ronljohnsonjr@xxxxxxxxx>

Date: 4/6/24 1:15 AM (GMT-05:00)

To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx

Subject: Re: How to tune SQL performance of function based columns of a view

On Sat, Apr 6, 2024 at 12:33 AM M Sarwar <sarwarmd02@xxxxxxxxxxx> wrote:

 

Hello,

 

I am working on SQL performance issue.

1. What PG version?

2. When did you last VACUUM and ANALYZE the base tables?