On Aug 19, 2012, at 8:01 PM, Scott Marlowe <scott.marl...@gmail.com> wrote:
> 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. 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general