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

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Re: How to tune SQL performance of function based columns of a view
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: How to tune SQL performance of function based columns of a view