Hacker News new | ask | show | jobs
by jwpapi 64 days ago
Does all of that apply to Postgresql as well or only Mysql?
1 comments

Both, assuming you’re ever going to index it - both use a form of a B+tree for their base indices.

If it’s just being stored in the table, it doesn’t matter, but also if it doesn’t matter, just use v7.

I haven't explored hash indexes enough. That might be one thing that differs between Postgres and MySQL, because for a long time Postgres didn't have a good story for those.