Re: pg_stat_advisor extension

2024-05-13 Thread Ilia Evdokimov
experiences and any improvements you might suggest. Best regards, Ilia Evdokimov Tantor Labs LLC. From eb998bea96a3640d240afa63e08cc8cf98925bf7 Mon Sep 17 00:00:00 2001 From: Ilia Evdokimov Date: Mon, 13 May 2024 14:41:59 +0300 Subject: [PATCH] 'pg_stat_advisor' extension This servic

Re: pg_stat_advisor extension

2024-02-08 Thread Ilia Evdokimov
On Feb 08 2024 at 07:14:18, Andrei Lepikhov wrote: 1. In the case of parallel workers the plan_rows value has a different semantics than the number of rows predicted. Just explore get_parallel_divisor(). Yes, this is a very weighty and important issue. I need to think about this very carefully

Re: pg_stat_advisor extension

2024-02-08 Thread Ilia Evdokimov
Our further discussion of this new extension takes place in this thread: https://www.postgresql.org/message-id/flat/f822b674-9697-43b9-931b-4d69729a26ff%40tantorlabs.com .Due to technical difficulties in the current thread, I will not be able to conduct a dialogue except in HTML format. And this wi

Re: pg_stat_advisor extension

2024-02-08 Thread Ilia Evdokimov
ng forward to your thoughts and feedback. Regards, Ilia Evdokimov, Tantor Labs LLC. From f87f4a57e532d57f43dab4764d08ddf83d9f3d8f Mon Sep 17 00:00:00 2001 From: Ilia Evdokimov Date: Thu, 8 Feb 2024 16:00:57 +0300 Subject: [PATCH] 'pg_stat_advisor' extension. This serves as a hook into t

Re: pg_stat_advisor extension

2024-02-07 Thread Andrei Lepikhov
On 6/2/2024 22:27, Ilia Evdokimov wrote: I welcome your insights, feedback, and evaluations regarding the necessity of integrating this new extension into PostgreSQL. Besides other issues that were immediately raised during the discovery of the extension, Let me emphasize two issues: 1. In the

Re: pg_stat_advisor extension

2024-02-07 Thread jian he
On Tue, Feb 6, 2024 at 12:06 AM Ilia Evdokimov wrote: > > Hi hackers, > > I'm reaching out again regarding the patch with new extension > 'pg_stat_advisor' aimed at enhancing query plan efficiency through the > suggestion of creating statistics. > > I understand the community is busy, but I woul

Re: pg_stat_advisor extension

2024-02-06 Thread Ilia Evdokimov
Dear Team, Firstly, I would like to extend my sincere apologies for the confusion and technical oversights in our previous discussions regarding the 'pg_stat_advisor extension'. To address this and facilitate a clearer, more focused dialogue, I have initiated a new thread to conso

Re: pg_stat_advisor extension

2024-02-06 Thread Ilia Evdokimov
extension into PostgreSQL. Kind regards, Ilia Evdokimov, Tantor Labs LLC. From 6316706c42996219e507bb6ded9dd1e872180e38 Mon Sep 17 00:00:00 2001 From: Ilia Evdokimov Date: Tue, 6 Feb 2024 18:11:04 +0300 Subject: [PATCH] pg_stat_advisor extension --- contrib/Makefile

Re: pg_stat_advisor extension

2024-02-05 Thread Ilia Evdokimov
Hi hackers, I'm reaching out again regarding the patch with new extension 'pg_stat_advisor' aimed at enhancing query plan efficiency through the suggestion of creating statistics. I understand the community is busy, but I would greatly value any feedback or thoughts on this extension. Thank you for

pg_stat_advisor extension

2024-01-30 Thread Илья Евдокимов
enterprisedb.com The 'pg_stat_advisor' extension is architected to optimize query plan. It operates by suggesting when to create extended statistics, particularly in queries where current selectivity estimates fall short. This is achieved through the GUC parameter 'pg_stat_advisor.s