Re: BitmapOr node not used in plan for ANY/IN but is for sequence of ORs ...

2024-11-14 Thread Jim Vanns
Thanks Tomas, that's useful to know. Cheers Jim On Wed, 13 Nov 2024 at 13:13, Tomas Vondra wrote: > On 11/13/24 13:08, Jim Vanns wrote: > > (sent to general users mailing list yesterday - but perhaps this is a > > more suitable audience?) > > > > In PG16.4, we have a table of key/pair data (ar

Re: BitmapOr node not used in plan for ANY/IN but is for sequence of ORs ...

2024-11-13 Thread Tomas Vondra
On 11/13/24 13:08, Jim Vanns wrote: > (sent to general users mailing list yesterday - but perhaps this is a > more suitable audience?) > > In PG16.4, we have a table of key/pair data (around 30M rows) where > there are about 7 distinct keys and each has a conditional or partial > index on them (th

BitmapOr node not used in plan for ANY/IN but is for sequence of ORs ...

2024-11-13 Thread Jim Vanns
(sent to general users mailing list yesterday - but perhaps this is a more suitable audience?) In PG16.4, we have a table of key/pair data (around 30M rows) where there are about 7 distinct keys and each has a conditional or partial index on them (the distribution is different for each key/value p