On Tue, Jul 10, 2012 at 1:09 AM, Steven Schlansker <steven(at)likeness(dot)com> wrote:
> 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.
You could use a slony slave and have different indexes etc between
master and slave but it's more complex to setup, maintain and monitor
for most people.