How does database indexing work? (2008)

Re:How does database indexing work? (2008) by settrans on Tuesday March 08, 2022 @11:13AM (#30601551)

Indeed, they perform much better, but caveat emptor: hash index operations are not currently WAL-logged. That means that: 1) if you crash during a hash index update, all bets are off and you'll have to rebuild, and 2) they will just be wrong in a replicated configuration.

EDIT: This is no longer true. Thanks latch!

[ Parent | on HN ]

Re:How does database indexing work? (2008) by latch on Tuesday March 08, 2022 @11:14AM (#30601576)

This was fixed in PG 10 (Oct 2017). See https://rhaas.blogspot.com/2017/09/postgresqls-hash-indexes-...

[ Parent | on HN ]

Re:How does database indexing work? (2008) by settrans on Tuesday March 08, 2022 @11:15AM (#30601596)

Oh, that's great news! (I last used evaluated them in August 2017)

[ Parent | on HN ]