Re: Relaxing constraints on BitmapAnd eligibility?

2025-02-26 Thread Dmytro Astapov
ff for convenience. Is this a generally desirable change to pursue? Best regards, Dmytro On Wed, Feb 26, 2025 at 7:31 PM Dmytro Astapov wrote: > Hi! > > I am (still) very unsure if the code change I mentioned will make sense, > but documentation chage could perhaps look like somethi

Re: Relaxing constraints on BitmapAnd eligibility?

2025-02-26 Thread Dmytro Astapov
Hi! I am (still) very unsure if the code change I mentioned will make sense, but documentation chage could perhaps look like something along these lines? Best regards, Dmytro On Tue, Feb 25, 2025 at 9:14 PM Dmytro Astapov wrote: > Hi! > > I've been investigating why postgr

Relaxing constraints on BitmapAnd eligibility?

2025-02-25 Thread Dmytro Astapov
Hi! I've been investigating why postgres does not do BitmapAnd of two well-suited indexes, and reading indxpath.c In my case, there is a table (d date, col1 int, col2 int) -- types not really important -- and there are two indices on (d,col1) and (d, col2). For queries that do WHERE d>=X AND col