Re: Improvement discussion of custom and generic plans

2024-02-19 Thread Quan Zongliang
Add the GUC parameter. On 2024/1/30 21:25, Quan Zongliang wrote: On 2023/11/3 15:27, Quan Zongliang wrote: Hi We have one such problem. A table field has skewed data. Statistics: n_distinct | -0.4481973 most_common_vals   | {5f006ca25b52ed78e457b150ee95a30c}

Re: Improvement discussion of custom and generic plans

2024-01-30 Thread Quan Zongliang
On 2023/11/3 15:27, Quan Zongliang wrote: Hi We have one such problem. A table field has skewed data. Statistics: n_distinct | -0.4481973 most_common_vals   | {5f006ca25b52ed78e457b150ee95a30c} most_common_freqs  | {0.5518474} Data generation: CREATE TABLE s_user (

Improvement discussion of custom and generic plans

2023-11-03 Thread Quan Zongliang
Hi We have one such problem. A table field has skewed data. Statistics: n_distinct | -0.4481973 most_common_vals | {5f006ca25b52ed78e457b150ee95a30c} most_common_freqs | {0.5518474} Data generation: CREATE TABLE s_user ( user_id varchar(32) NOT NULL, corp_id