Fw: Re: Bitmap scan seem like such a strange choice when "limit 1"

2020-09-07 Thread Klaudie Willis
> t > '2020-01-01'::timestamp and t < '2021-01-01'::timestamp >Not at all important, but it seems odd to be exclusive of the start and end >both. I would >consider including the start with >= >Michael Lewis | Database Engineer >Entrata Michael, funny I was thinking that myself minutes after posti

Fw: Re: Bitmap scan seem like such a strange choice when "limit 1"

2020-09-07 Thread Klaudie Willis
‐‐‐ Original Message ‐‐‐ On Monday, September 7, 2020 9:04 AM, Klaudie Willis wrote: > Maybe the right way to improve this is to bypass add_paths_to_append_rel > entirely when there's exactly one surviving child rel, and make it > just use all the surviving paths for that child. > re