Postgres Pro
Downloads
Home   >   mailing lists

Re: Why is Hash index not transaction safe. - Mailing list pgsql-novice

From Luca Ferrari
Subject Re: Why is Hash index not transaction safe.
Date
Msg-id CAKoxK+7=AtQZR1+gMwy7gCS6GfrW4YJQ3d81WkfF3xn6FuBOPw@mail.gmail.com
Whole thread Raw
In response to Re: Why is Hash index not transaction safe.  (Bruce Momjian <bruce@momjian.us>)
List pgsql-novice
Tree view 
On Sun, May 10, 2015 at 1:17 AM, Bruce Momjian <bruce@momjian.us> wrote:
>         WARNING:  hash indexes are not WAL-logged and their use is discouraged
>

I'd like to understand better why hash index operations are not
inserted into WALs.

Thanks,
Luca

pgsql-novice by date:

Previous
From: Pascal Cloup
Date:
Subject: Re: count of databases by role/user
Next
From: Sameer Kumar
Date:
Subject: Understanding GROUP BY Plan in PostgreSQL