Greenplum Team有一个源自从Pivotal时代的晨会仪式，称为Big Standup。2020年4月，被收购成为VMware Greenplum后，由于VMware的未来办公模式，永久的远程办公（甚至可以改Base），中国团队每天的Standup改为线上的zoom，为了更加活泼有趣，主持人需要想一个游戏，或者做一个小分享。这个活动成为了每天最吸引人的事情了。
有一个同事，找了一个有趣的类似华容道的益智游戏，对应的网站是 https://www.dogbunnypuzzle.com/。2022年12月24日的那个关卡如下图:
Last week I have a discussion with a colleague who is working on improving the analyze-speed of AO|AOCS table in Greenplum (at least 10x speed up). We search the Internet and do not find the performance analysis of Algorithm S and Knuth’s TAOCP left this (mean and var) as exercises. This blog is the solution to Knuth’s exercises.
Continue reading不踬于山，而踬于垤。—— 先秦圣谚
最近在Greenplum 6X上发现了一个内存泄漏，Memory Leak DynamicBitmap Index Scan in Nestloop’s inner plan #14122, 查询和查询计划与和之前修复过的如出一辙，所以肯定是来了新的泄漏。这一次可以复现问题，能复现的bug，修复只是时间问题，我的同事此刻已经搞定了，开出了Pull Request (见Issue页面)。本文是我做事后诸葛亮，看看能否用一些工具快速定位这个问题。
Continue reading今天在公司用白板做了一个简单的讲座，介绍如何用Analytical Combinatorics研究组合结构，分析算法。内容如下:
视频在此
Continue readingGreenplum team will do big-standup each workday. The team hosting the big-standup will try to find some interesting games for the whole team to play during the big-standup. Today one colleague comes up with a game to write regular expression for given DFA. The RE is so cute that I cannot resist writing it down.
Continue readingI solved the problem about 2 years ago and it was the Problem 1 of Final exam of EE of THU (see my previous solution here). That time I did not use symbolic method. Not sure why, a symbolic method just comes to my mind and here comes the blog.
Continue readingSee the PDF version of the article. It can also be downloaded here.
Continue readingRecently I have been working on several issues involving relation_size in Greenplum, this post is to summarize some interesting parts of the topic. I also post a thread on gpdb-dev mailing list: https://groups.google.com/a/greenplum.org/g/gpdb-dev/c/DkTx4O-kuH0.
Q: there is a table storing some other tables’ oid, how to write a SQL to compute table size for each oid?
This problem is so simple in Postgres (single instance), but it turns much more complex than the first glance to work this out high efficiently in Greenplum.
Continuing with previous notes of Abstract Algebra, here we come to the concept of Rings. This time we use the textbook of Tom Judson’s Abstract Algebra: Theory and Applications.
Continue readingRecently I spend some time on doing the homework of UCB math113, here is group part.
Continue reading