Hacker News new | ask | show | jobs
by idiocrat 628 days ago
> Learn your DB server. Check the query plans often. You might get surprised. Tweak and recheck.

Oftentimes the well-designed queries behave unexpectedly, because the column statistics are not updated or when the data is fragmented for big tables (e.g. random PK insertion).

1 comments

Sounds like that DBMS would work better with serial int PKs