On Tue, Jul 10, 2012 at 1:09 AM, Steven Schlansker <ste...@likeness.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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
