How Levels.fyi Built Scalable Search with PostgreSQL
levels.fyi
How Levels.fyi Built Scalable Search with PostgreSQL
- Always use BUFFERS when running an EXPLAIN . It gives some data that may be crucial for the investigation.
- Always, always try to get an Index Cond (called Index range scan in MySQL) instead of a Filter .
- Always, always, always assume PostgreSQL and MySQL will behave differently. Because they do.
