@pgsql_guo profile picture
Richard Guo @pgsql_guo

PostgreSQL Developer

Joined August 2023
  • Tweets 13
  • Following 61
  • Followers 32
Photos and videos
Richard Guo@pgsql_guo
26 Jun 2024
Many thanks to Antti Lampinen for reporting a wrong results issue with merge-right-anti-join. I can't imagine how awful I would feel if this issue had persisted in production for a longer time. postgresql.org/message-id/fl…
1
169
Richard Guo retweeted
Joe Hellerstein@joe_hellerstein
4 Apr 2024
The NYTimes disappoints again. :-(
66
112
3,626
405,968
Richard Guo retweeted
Satya Nadella
@satyanadella
31 Mar 2024
Love seeing how @AndresFreundTec, with his curiosity and craftsmanship, was able to help us all. Security is a team sport, and this is the culture we need everywhere. securityboulevard.com/2024/0…

An Accidental Discovery of a Backdoor Likely Prevented Thousands of Infections

... Read more » The post An Accidental Discovery of a Backdoor Likely Prevented Thousands of Infections appeared first on Deepfactor.

securityboulevard.com
52
365
2,019
464,146
Richard Guo retweeted
Joseph Conway
@josepheconway
3 Mar 2024
Congratulations to new and updated PostgreSQL Contributors! postgresql.org/message-id/cc…

PostgreSQL Contributors Updates

All, The PostgreSQL Contributor Page (https://www.postgresql.org/community/contributors/) includes people who have made substantial, long-term contributions of time and effort to the …

postgresql.org
12
41
14,854
Richard Guo retweeted
Planet PostgreSQL@planetpostgres
8 Feb 2024
David Rowley (@citusdata): What’s new in the Postgres 16 query planner / optimizer postgr.es/p/6lO

What’s new in the Postgres 16 query planner / optimizer

Postgres 16 introduces quite a few improvements to the query planner and makes many SQL queries run faster than they did on previous versions of PostgreSQL. This post is a deep dive into 10 of the...

citusdata.com
24
55
7,071
Glad to be part of it.
DB-Engines@DBEngines
2 Jan 2024
PostgreSQL is the DBMS of the Year db-engines.com/en/blog_post/… @PostgreSQL #PostgreSQL
103
Richard Guo@pgsql_guo
25 Sep 2023
Maybe we need to mark Vars nullable by grouping sets, just like we mark Vars nullable by outer joins. Doing that will help fix several long existing semantic bugs in grouping sets. #postgres postgresql.org/message-id/CA…

Wrong results with grouping sets

I think I've come across a wrong result issue with grouping sets, as shown by the query below. -- result …

postgresql.org
3
112
While working on a crash issue in expandRecordVariable() I found another one that happens in get_name_for_var_field() by grepping the source codes. #postgres
1
1
143
This reminds me of a quote from Tom Lane: (A wise man once said that the most powerful bug-finding heuristic he knew was "where else did we make this same mistake?" ). It's so true.
1
139
Started looking at the codes in reparameterize_path_by_child() and ended up going down a rabbit hole.. postgresql.org/message-id/fl…
129
Richard Guo retweeted
PostgreSQL@PostgreSQL
31 Aug 2023
News: PostgreSQL 16 RC1 Released! postgresql.org/about/news/po…

PostgreSQL 16 RC1 Released!

The PostgreSQL Global Development Group announces that the first release candidate of PostgreSQL 16 is now available for download. As …

postgresql.org
1
31
63
8,372
Load more