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

From: M Sarwar <sarwarmd02(at)outlook(dot)com>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: RE: How to tune SQL performance of function based columns of a view
Date: 2024-04-06 08:44:21
Message-ID: DM4PR19MB5978DFB2A7796FEE4DDE8A1AD3022@DM4PR19MB5978.namprd19.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmail(dot)com>
Date: 4/6/24 1:15 AM (GMT-05:00)
To: pgsql-admin(at)lists(dot)postgresql(dot)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(at)outlook(dot)com<mailto:sarwarmd02(at)outlook(dot)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?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2024-04-06 13:58:24 Re: How to tune SQL performance of function based columns of a view
Previous Message Ron Johnson 2024-04-06 05:14:56 Re: How to tune SQL performance of function based columns of a view