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 |
| Дата | |
| Msg-id | CANzqJaAgBtJ7sFWR6oTF5Zdo-nHiZLcuC3GF-9xsG+xH6azCig@mail.gmail.com обсуждение исходный текст |
| Ответ на | RE: How to tune SQL performance of function based columns of a view (M Sarwar <sarwarmd02@outlook.com>) |
| Ответы |
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 |
| Список | pgsql-admin |
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,SarwarSent 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 viewOn 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 по дате отправления: