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 DM4PR19MB597891E91B5A8AFD97D27564D3002@DM4PR19MB5978.namprd19.prod.outlook.com
обсуждение исходный текст
Ответ на Re: How to tune SQL performance of function based columns of a view  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список 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.albe@cybertec.at>
Sent: Monday, April 8, 2024 5:56 AM
To: M Sarwar <sarwarmd02@outlook.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.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

В списке pgsql-admin по дате отправления:

Предыдущее
От: M Sarwar
Дата:
Сообщение: Re: How to tune SQL performance of function based columns of a view
Следующее
От: Wolfgang Wilhelm
Дата:
Сообщение: Re: Dynamic views