Re: maximum columns for brin bloom indexes

2021-04-08 Thread Tomas Vondra
On 4/8/21 4:49 PM, Jaime Casanova wrote: > On Thu, Apr 08, 2021 at 12:18:36PM +0200, Tomas Vondra wrote: >> On 4/8/21 9:08 AM, Jaime Casanova wrote: >>> Hi everyone, >>> >>> When testing brin bloom indexes I noted that we need to reduce the >>> PAGES_PER_RANGE parameter of the index to allow mor

Re: maximum columns for brin bloom indexes

2021-04-08 Thread Jaime Casanova
On Thu, Apr 08, 2021 at 12:18:36PM +0200, Tomas Vondra wrote: > On 4/8/21 9:08 AM, Jaime Casanova wrote: > > Hi everyone, > > > > When testing brin bloom indexes I noted that we need to reduce the > > PAGES_PER_RANGE parameter of the index to allow more columns on it. > > > > Sadly, this could be

Re: maximum columns for brin bloom indexes

2021-04-08 Thread Tomas Vondra
On 4/8/21 9:08 AM, Jaime Casanova wrote: > Hi everyone, > > When testing brin bloom indexes I noted that we need to reduce the > PAGES_PER_RANGE parameter of the index to allow more columns on it. > > Sadly, this could be a problem if you create the index before the table > grows, once it reaches