Re: Columns correlation and adaptive query optimization - Mailing list pgsql-hackers

From Yugo NAGATA
Subject Re: Columns correlation and adaptive query optimization
Date
Msg-id 20210319181726.fdbc36fb8935301010554681@sraoss.co.jp
Whole thread Raw
In response to Columns correlation and adaptive query optimization  (Konstantin Knizhnik <k.knizhnik@postgrespro.ru>)
Responses Re: Columns correlation and adaptive query optimization  (Konstantin Knizhnik <k.knizhnik@postgrespro.ru>)
List pgsql-hackers
On Wed, 10 Mar 2021 03:00:25 +0100
Tomas Vondra <tomas.vondra@enterprisedb.com> wrote:

> What is being proposed here - an extension suggesting which statistics
> to create (and possibly creating them automatically) is certainly
> useful, but I'm not sure I'd call it "adaptive query optimization". I
> think "adaptive" means the extension directly modifies the estimates
> based on past executions. So I propose calling it maybe "statistics
> advisor" or something like that.

I am also agree with the idea to implement this feature as a new 
extension for statistics advisor.

> BTW Why is "qual" in
> 
>   static void
>   AddMultiColumnStatisticsForQual(void* qual, ExplainState *es)
> 
> declared as "void *"? Shouldn't that be "List *"?

When I tested this extension using TPC-H queries, it raised segmentation
fault in this function. I think the cause would be around this argument.

Regards,
Yugo Nagata

-- 
Yugo NAGATA <nagata@sraoss.co.jp>



pgsql-hackers by date:

Previous
From: "houzj.fnst@fujitsu.com"
Date:
Subject: RE: Parallel Inserts in CREATE TABLE AS
Next
From: Fujii Masao
Date:
Subject: Re: Wrong statistics for size of XLOG_SWITCH during pg_waldump.