Ignore hash indices on replicas

From: Steven Schlansker <steven(at)likeness(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Ignore hash indices on replicas
Date: 2012-07-10 07:09:48
Message-ID: 84691ED0-98AB-4AA7-AEC4-459807020156@likeness.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm using Postgres hash indices on a streaming replica master.
As is documented, hash indices are not logged, so the replica does not have access to them.

I understand that the current wisdom is "don't use hash indices", but (unfortunately?) I have benchmarks that
show that our particular application is faster by quite a bit when a hash index is available.

I assume that fixing the hash index logging issue hasn't been a priority due to low interest / technical limitations, but I'm curious for a stopgap measure -- can we somehow configure Postgres to ignore hash indices on a replica, using other b-tree indices or even a sequential scan? I know I can do this on a per-connection basis by disabling various index lookup methods, but it'd be nice if it just ignored invalid indices on its own.

I've not seen much reference to this problem around, but I do apologize if I've missed it in the manual or it is extremely obvious how you do this :)

Thanks,
Steven

Responses

Browse pgsql-general by date

  From Date Subject
Next Message tuanhoanganh 2012-07-10 07:27:00 PL/Python error fetching next item from iterator
Previous Message Stefan Schwarzer 2012-07-10 05:31:53 Re: ERROR: function crosstab(unknown, unknown) does not exist