On Aug 19, 2012, at 8:01 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > 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. Thanks for the suggestion, but we finally have replication working in a way we understand / like and I don't really consider this a viable option. The built-in replication has been treating us very well. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
