Re: Why is Hash index not transaction safe.

From: Luca Ferrari <fluca1978(at)infinito(dot)it>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Why is Hash index not transaction safe.
Date: 2015-05-12 07:07:16
Message-ID: CAKoxK+7=AtQZR1+gMwy7gCS6GfrW4YJQ3d81WkfF3xn6FuBOPw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Sun, May 10, 2015 at 1:17 AM, Bruce Momjian <bruce(at)momjian(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Sameer Kumar 2015-05-14 01:01:33 Understanding GROUP BY Plan in PostgreSQL
Previous Message Pascal Cloup 2015-05-11 17:43:31 Re: count of databases by role/user