Re: Question on indexes - Mailing list pgsql-general

From Efrain J. Berdecia
Subject Re: Question on indexes
Date
Msg-id 2079480455.569271.1728609474771@mail.yahoo.com
Whole thread Raw
In response to Re: Question on indexes  (Christophe Pettus <xof@thebuild.com>)
List pgsql-general
They are extremely efficient for joins!!!


On Thu, Oct 10, 2024 at 2:52 PM, Christophe Pettus
<xof@thebuild.com> wrote:


> On Oct 10, 2024, at 11:49, sud <suds1434@gmail.com> wrote:
>
> Hi,
> I have never used any 'hash index' but saw documents in the past suggesting issues around hash index , like WAL doesnt generate for "hash index" which means we can't get the hash index back after crash also they are not applied to replicas etc.


That's very old information.  Hash indexes are correctly WAL-logged since (IIRC) version 10.


pgsql-general by date:

Previous
From: Erik Wienhold
Date:
Subject: Re: Question on indexes
Next
From: Laurenz Albe
Date:
Subject: Re: Question on indexes