> On Feb 8, 2023, at 14:14, Siddharth Jain <siddhsql@xxxxxxxxx> 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.
