| From: | "Efrain J(dot) Berdecia" <ejberdecia(at)yahoo(dot)com> |
|---|---|
| To: | xof(at)thebuild(dot)com, 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-11 01:17:54 |
| Message-ID: | 2079480455.569271.1728609474771@mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
They are extremely efficient for joins!!!
Yahoo Mail: Search, Organize, Conquer
On Thu, Oct 10, 2024 at 2:52 PM, Christophe Pettus<xof(at)thebuild(dot)com> wrote:
> 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2024-10-11 06:43:37 | Re: Question on indexes |
| Previous Message | Erik Wienhold | 2024-10-10 20:36:47 | Re: Question on indexes |