Re: Adaptive Plan Sharing for PreparedStmt

2021-05-25 Thread Andy Fan
Hi, On Thu, May 20, 2021 at 5:02 PM Tomas Vondra wrote: > Hi, > > On 5/20/21 5:43 AM, Andy Fan wrote: > > Currently we are using a custom/generic strategy to handle the data skew > > issue. However, it doesn't work well all the time. For example: SELECT * > > FROM t WHERE a between $1 and $2. W

Re: Adaptive Plan Sharing for PreparedStmt

2021-05-20 Thread Tomas Vondra
Hi, On 5/20/21 5:43 AM, Andy Fan wrote: Currently we are using a custom/generic strategy to handle the data skew issue. However, it doesn't work well all the time. For example:  SELECT * FROM t WHERE a between $1 and $2. We assume the selectivity is 0.0025, But users may provide a large range ev