Postgres Pro
Downloads
Home   >   mailing lists

Re: How to tune SQL performance of function based columns of a view - Mailing list pgsql-admin

From Ron Johnson
Subject Re: How to tune SQL performance of function based columns of a view
Date
Msg-id CANzqJaAgBtJ7sFWR6oTF5Zdo-nHiZLcuC3GF-9xsG+xH6azCig@mail.gmail.com
Whole thread Raw
In response to RE: How to tune SQL performance of function based columns of a view  (M Sarwar <sarwarmd02@outlook.com>)
Responses Re: How to tune SQL performance of function based columns of a view
Re: How to tune SQL performance of function based columns of a view
List pgsql-admin
Tree 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@outlook.com> 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@gmail.com>
Date: 4/6/24 1:15 AM (GMT-05:00)
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@outlook.com> wrote:
 

Hello,

 

I am working on SQL performance issue.


1. What PG version?
2. When did you last VACUUM and ANALYZE the base tables?
 

pgsql-admin by date:

Previous
From: M Sarwar
Date:
Subject: RE: How to tune SQL performance of function based columns of a view
Next
From: M Sarwar
Date:
Subject: Re: How to tune SQL performance of function based columns of a view