"Jan Kantert" <jan-postgres(at)kantert(dot)net> writes:
> After we created the index again, we saw strange problems on the slave:
> master=# CREATE INDEX index_user_lower_login ON users USING hash
> (lower(login::text));
Hash indexes are not replicated. There's seldom any very good reason to
use them in practice, because they also have no WAL protection and don't
perform very well anyway. Why did you pick a hash index for a
production application?
regards, tom lane