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

[M Sarwar <sarwarmd02@xxxxxxxxxxx>]

Hi Ron,

Yes, it is identified that it was missing stats due to missing analysis. Last_analyzed column was null.

Default parameters Postgres are analyzing but they are slow. I need to step up at least analyzing if not Vacuuming.

We do have scheduled loading and cleaning jobs which are going to impact the analysis of the tables.

Thank you!

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?