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

I think a nicer takeaway is what the author summarized with:

1. Always use BUFFERS when running an EXPLAIN. It gives some data that may be crucial for the investigation.

2. Always, always try to get an Index Cond (called Index range scan in MySQL) instead of a Filter.

3. Always, always, always assume PostgreSQL and MySQL will behave differently. Because they do.



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

Search: