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

It’s very cool, but at high throughput you really see the difference. This bitmap scan can take huge amounts of cpu, reduced to nothing (and much faster) when setting up a proper multi column index.

On small/medium tables and lowish throughout though, yeah it’s often good enough and avoids having many indexes for specific use cases (which is a cost in itself, in memory/cpu/storage)



Do you have any benchmarks? Be interesting to compare.




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

Search: