On Tue, Jul 10, 2012 at 1:09 AM, Steven Schlansker <steven@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
