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
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 |