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

Поиск
Список
Период
Сортировка
От M Sarwar
Тема Re: How to tune SQL performance of function based columns of a view
Дата
Msg-id DM4PR19MB597858BBB512F67EAAE6FC2FD3022@DM4PR19MB5978.namprd19.prod.outlook.com
обсуждение исходный текст
Ответ на Re: How to tune SQL performance of function based columns of a view  (Ron Johnson <ronljohnsonjr@gmail.com>)
Список pgsql-admin
Дерево обсуждения
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@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.

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 по дате отправления: