From: | M Sarwar <sarwarmd02(at)outlook(dot)com> |
---|---|
To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, "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-08 22:28:39 |
Message-ID: | DM4PR19MB597891E91B5A8AFD97D27564D3002@DM4PR19MB5978.namprd19.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi Lauren,
I thought that I have tried this option but I am try this option another time.
Thanks,
Sarwar
________________________________
From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Sent: Monday, April 8, 2024 5:56 AM
To: M Sarwar <sarwarmd02(at)outlook(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
On Sat, 2024-04-06 at 04:33 +0000, M Sarwar wrote:
> I am working on SQL performance issue.
>
> After analyzing the results from the file, Explain-Analyze-Net-Temps-Slow-Response-Bao.xlsx,
> I tried to create several indexes one by one based on the possibility from Explain analyze
> results and none of them are helping in improving the performance of SQL.
> I am just trying to know what are the other approaches which I can use to resolve this performance issue.
According to my reading of the execution plan, the following index should help a lot:
CREATE INDEX ON test_part_details_all_mcm_mid (serial_number, stage, temperature);
There might be more gains in rewriting whatever caused this subquery.
Yours,
Laurenz Albe
From | Date | Subject | |
---|---|---|---|
Next Message | Wolfgang Wilhelm | 2024-04-09 09:18:47 | Re: Dynamic views |
Previous Message | M Sarwar | 2024-04-08 22:26:55 | Re: How to tune SQL performance of function based columns of a view |