They are extremely efficient for joins!!! Yahoo Mail: Search, Organize, Conquer On Thu, Oct 10, 2024 at 2:52 PM, Christophe Pettus<x...@thebuild.com> wrote:
> On Oct 10, 2024, at 11:49, sud <suds1...@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.
