Re: Question on indexes

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: sud <suds1434(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Question on indexes
Date: 2024-10-10 18:51:58
Message-ID: 56CE69DD-FFC8-45A4-8EF6-513BB011310F@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Oct 10, 2024, at 11:49, sud <suds1434(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Erik Wienhold 2024-10-10 19:21:46 Re: Question on indexes
Previous Message sud 2024-10-10 18:49:39 Question on indexes