Expert in tackling complex software challenges, with deep knowledge of TCP, MySQL and PostgreSQL kernels, and a passion for AI, history, math, and physics.
Joined October 2012
- Tweets 3,127
- Following 131
- Followers 17,653
- Likes 1,355
373 Photos and videos
May 24
The database world is complex, especially Postgres. To truly understand how Postgres works inside, AI needs enough accurate trace data. That’s why I spent so much time building a trace tool.
2
3
69
6,897
May 22
The deeper I studied Postgres extensions, especially TimescaleDB, pgvector, PostGIS, and PL/pgSQL, the more I realized how amazing Postgres’s design is. It took me another month to really understand how they work inside.
2
6
99
5,665
May 15
This paper is really eye-opening for MySQL users. The interesting part is that Postgres actually built GiST like this.
5
70
3,320
May 15
Most core mechanisms in MySQL and Postgres are no longer a mystery. Sometimes, knowing too much takes away the beauty.
2
28
2,369
Apr 28
The Postgres course will likely be upgraded before June 1, with more planner details and broader coverage of extensions. It might become one of the most technically deep courses I’ve ever built.
1
25
1,721
Apr 28
I saw a strange SQL query (refer to imdbload’s 26c.sql): with Postgres parallel execution on, it finished in seconds; with it off, it couldn’t finish even after hours.
Smart people probably already know why.
1
22
5,028
Apr 27
MySQL 9.7 suddenly giving the Community Edition the hypergraph optimizer and a sane Hash Join cost model feels like a classic case of “a man speaks kindly when death is near.”
1
29
3,768
Apr 27
Beyond PostGIS, pgvector, TimescaleDB, and Citus, which Postgres extensions are truly worth tracing next?
8
4
93
12,244
Mar 26
To truly understand MySQL, you need to understand how Postgres approaches the same problems.The intermediate MySQL course is expected to be completed before May 1.
1
45
2,818
Mar 7
Postgres handles this very well, with a very safe optimizer.
Mar 7
Be careful with complex SQL in MySQL. One bad plan can create a Cartesian product and bring your server down by consuming massive disk space. Postgres usually handles the same SQL much more safely.
1
2
44
3,593
Mar 7
Be careful with complex SQL in MySQL. One bad plan can create a Cartesian product and bring your server down by consuming massive disk space. Postgres usually handles the same SQL much more safely.
2
2
49
7,287
Mar 6
If you love database engineering, these ten papers are must-reads. Most are easy to follow, and you’ll learn a lot. Dive in and enjoy! Do some trace analysis, and you’ll get even more out of them.
3
47
512
19,359
Mar 6
AI’s analytical ability is getting stronger and stronger. With sufficient and accurate trace data, it can analyze SQL execution very accurately. For those who truly love databases, this could be the ultimate enjoyment.
1
33
2,086
Mar 5
While MySQL surprisingly allows derived table merging when RAND() is used without a LIMIT, Postgres never merges in such situations.
23
1,918
Mar 4
If you’re interested in learning more about the optimizer, you can read these papers.
3
14
215
8,281
Mar 3
Your database career isn't complete until you've faced a problem caused by join selectivity, such as the one described in this article.
Mar 2
If you want to become a database genius among your peers, you need to read this article. It offers invaluable insights that could mark the beginning of your breakthrough in the database field.
7
78
4,593
Mar 3
This is proof that MySQL's official code review isn't rigorous, because the comments and the code are inconsistent with each other.
3
2
86
16,693
Mar 2
For complex SQL queries, sometimes it's nearly impossible for the optimizer alone to find the optimal execution plan. Those who find why it chose a bad plan are geniuses; those who find the best plan are database gods.
Mar 2
If you want to become a database genius among your peers, you need to read this article. It offers invaluable insights that could mark the beginning of your breakthrough in the database field.
2
5
89
6,340
Mar 2
Anyone can become an expert in query optimizers, and this paper is the best guide to get you started.
4
56
439
14,299
Mar 2
If you want to become a database genius among your peers, you need to read this article. It offers invaluable insights that could mark the beginning of your breakthrough in the database field.
3
87
975
47,345