They are extremely efficient for joins!!!
On Thu, Oct 10, 2024 at 2:52 PM, Christophe Pettus
<xof@xxxxxxxxxxxx> wrote:
> On Oct 10, 2024, at 11:49, sud <
suds1434@xxxxxxxxx> 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.
