Re: How to use the BRIN index properly?

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Siddharth Jain <siddhsql(at)gmail(dot)com>
Cc: Ron <ronljohnsonjr(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: How to use the BRIN index properly?
Date: 2023-02-08 22:16:19
Message-ID: C6390B56-9402-4CCE-957F-1F6552AA53AC@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Feb 8, 2023, at 14:14, Siddharth Jain <siddhsql(at)gmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Smith 2023-02-08 22:16:49 Re: Support logical replication of DDLs
Previous Message Siddharth Jain 2023-02-08 22:14:46 Re: How to use the BRIN index properly?