Re: Question on indexes - Mailing list pgsql-general

From Christophe Pettus
Subject Re: Question on indexes
Date
Msg-id 56CE69DD-FFC8-45A4-8EF6-513BB011310F@thebuild.com
Whole thread Raw
In response to Question on indexes  (sud <suds1434@gmail.com>)
Responses Re: Question on indexes
List pgsql-general

> 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
doesntgenerate for "hash index" which means we can't get the hash index back after crash also they are not applied to
replicasetc. 

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


pgsql-general by date:

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