Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

I'm still dubious of any micro benchmark that says "x is better than y" since these are often not real world work loads.

Tuning/optimization starts with using the right schema.



Hash indexes are "the right way" to speed-up index lookups.

They aren't used in Postgres because their implementation there has many problems. One of them is that they are slower than the theoretically suboptimal B-trees. In the process of fixing those problems, people will compare both indexes many times.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: