Re: How to use the BRIN index properly?

[Christophe Pettus]

> On Feb 8, 2023, at 14:14, Siddharth Jain <siddh...@gmail.com> wrote:
> 
> If the B-Tree index will be so large that it cannot fit in memory, then is it 
> worth creating it at all? 

Yes.  Of course, more memory is better, and more recently versions of 
PostgreSQL have optimizations that are valuable for large B-tree indexes.