He/His

学问中便是正事。此刻于小事上用学问一提，那小事越发作高一层了。不拿学问提着，便都流入市俗去了。

Learning, in essence, is the right thing to do. When we apply learning even to minor matters, those minor matters become elevated. Without the guidance of learning, everything would degenerate into vulgarity.

Too Many Hash Joins in Postgres Will Consume Disastrous Disk Volume

less than 1 minute read

Published:

It seems that 200GB storage aren’t enough for a terrible query plan. If we use too many Hash Joins in a complicated SQL(like those in Join Order Benchmark), there will be a spike in the disk usage and if it exceeds the ceiling, well then the process will crash :(

So maybe I need to set a monitor on the disk usage, once it will exceed the ceiling with a high probabilty, just cancel this query plan and mark a special sign there in the Weight & Bias log.

I’m glad I’m not the person who will pay the bill:)

“Almost 30-40 dollars vanished”

“Crashes in Weights & Bias”

Bye Year2024

less than 1 minute read

Published:

Today marks the beginning of 2025. Reflecting on 2024, it was a year filled with challenges for me. Whether in scientific research, emotional life, economic pressures, or interpersonal relationships and self-regulation, I faced numerous difficulties that often left me feeling exhausted. At times, I lamented the lack of recognition and support, despite my significant efforts which seemed to yield limited results. However, I take solace in the fact that these experiences have made me stronger and more resilient. While I may keep my vulnerabilities hidden, my outer resolve has grown increasingly robust. Regardless of the outcome, I will approach the uncertain future calmly, striving to be more knowledgeable and resilient each day.

Submitted All My PhD Applicatons

1 minute read

Published:

Thanks for all the professors and students who helped and guided me these years, the DB rersearch is too hard compared to AI. But I think I’m gradually used to it! And willing to contribute to this area in my future PhD life.

Overcame the M3!!!

2 minute read

Published:

I once thought “M3” only referred to Apple’s chip series, or a kind of beef quality, never imagining it was also a type of leukemia. I used part of my living expenses to help cover the exorbitant cost of my boyfriend’s treatment, but as the bills piled up and his condition showed no improvement, I felt utterly helpless. At times I found myself on the rooftop, silently crying as the sun set over Los Angeles and sank into the horizon. To save money, I limited myself to one formal meal a day at the campus dining hall, and the weight I lost was a visible testament to the strain. Most of my monthly TA salary was sent back to him, each time the US Dollar was appreciated, it brought a small but meaningful sense of relief, helping to alleviate the financial strain. How long haven’t I go out for fun? I just couldn’t remember, even someone can say they don’t care about money, but when the situation is really bad, money is just like your god, even the least holy type. I came to fully grasp the harshness and weight of reality, understanding for the first time the true meaning of “scraping together every silver coin.” Like a Chinese song 《半生已过》（Half of My Life has past）by 张良 (Liang Zhang),”都说碎银解千愁，奈何碎银最难求。如若故里可安生，谁愿异乡寒水流。”

First Version of Paper Finished!

less than 1 minute read

Published:

Finished my first version of paper! Hope it could be submitted and admitted by SIGMOD.