Richard Guo

guofenglinux@gmail.com

Email: guofenglinux@gmail.com
Name: Richard Guo
Messages: 0
First message:
Last message:

Recent messages

DateSubject
2026-05-28T09:11:25Z Re: Fix HAVING-to-WHERE pushdown with mismatched operator families
2026-05-26T23:04:17Z Re: Fix HAVING-to-WHERE pushdown with mismatched operator families
2026-05-26T08:48:24Z Fix HAVING-to-WHERE pushdown with mismatched operator families
2026-05-25T21:01:08Z Re: Remove inner joins based on foreign keys
2026-05-08T08:15:04Z Re: Wrong results in remove_useless_groupby_columns()
2026-05-08T08:07:07Z Re: Fix HAVING-to-WHERE pushdown with nondeterministic collations
2026-05-08T00:15:50Z Re: Wrong results in remove_useless_groupby_columns()
2026-05-05T10:12:16Z Wrong results in remove_useless_groupby_columns()
2026-05-05T02:06:58Z Re: Wrong results from inner-unique joins caused by collation mismatch
2026-05-01T08:25:13Z Re: Remove inner joins based on foreign keys
2026-05-01T02:47:20Z Re: Fix HAVING-to-WHERE pushdown with nondeterministic collations
2026-05-01T01:16:24Z Re: First draft of PG 19 release notes
2025-12-30T03:47:51Z Re: GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized)
2025-12-29T08:12:15Z Re: Lost update in an ordered batch, but only with index scan
2025-12-28T04:20:58Z Re: GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized)
2025-12-27T05:12:06Z Re: BUG #19363: PostgreSQL shared memory exhaustion during query execution involving views and parallel workers
2025-12-25T03:58:47Z Re: BUG #19353: Error XX000 if referencing expanded array in grouping set: variable not found in subplan target list
2025-12-24T10:05:46Z Re: Some optimizations for COALESCE expressions during constant folding
2025-12-24T07:50:27Z Re: GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized)
2025-12-24T02:15:34Z Re: BUG #19353: Error XX000 if referencing expanded array in grouping set: variable not found in subplan target list
2025-12-18T08:56:08Z Re: GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized)
2025-12-15T14:28:54Z Re: BUG #19353: Error XX000 if referencing expanded array in grouping set: variable not found in subplan target list
2025-12-12T09:28:43Z Re: GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized)
2025-12-12T02:17:07Z Re: Some optimizations for COALESCE expressions during constant folding
2025-12-10T02:17:29Z Re: Issue with query_is_distinct_for() and grouping sets
2025-12-10T02:11:53Z Re: BUG #19007: Planner fails to choose partial index with spurious 'not null'
2025-12-10T02:01:49Z Re: GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized)
2025-12-09T06:38:09Z Re: GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized)
2025-12-08T06:10:27Z Re: GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized)
2025-12-04T02:53:15Z Re: apply_scanjoin_target_to_paths and partitionwise join
2025-12-03T06:39:04Z Re: Some optimizations for COALESCE expressions during constant folding
2025-12-02T02:15:43Z Re: apply_scanjoin_target_to_paths and partitionwise join
2025-12-01T08:11:25Z Re: Some optimizations for COALESCE expressions during constant folding
2025-11-26T11:55:22Z Re: Some optimizations for COALESCE expressions during constant folding
2025-11-26T06:33:31Z Re: Some optimizations for COALESCE expressions during constant folding
2025-11-25T10:50:51Z Some optimizations for COALESCE expressions during constant folding
2025-11-19T10:07:26Z Re: GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized)
2025-11-19T02:18:23Z Re: Fix typos in ExecChooseHashTableSize()
2025-11-18T08:27:40Z Re: GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized)
2025-11-17T07:28:45Z Re: Use exact nullingrels matches for NestLoopParams
2025-11-13T03:49:17Z Re: BUG #19106: Potential regression with CTE materialization planning in Postgres 18
2025-11-12T07:04:05Z Re: BUG #19106: Potential regression with CTE materialization planning in Postgres 18
2025-11-11T06:58:31Z Use exact nullingrels matches for NestLoopParams
2025-11-05T10:19:15Z Re: BUG #19102: Assertion failure in generate_orderedappend_paths with aggregate pushdown
2025-11-05T03:47:37Z Re: Fix comments for ChangeVarNodes() and related functions
2025-11-05T01:50:15Z Re: BUG #19102: Assertion failure in generate_orderedappend_paths with aggregate pushdown
2025-11-05T01:36:38Z Re: BUG #19102: Assertion failure in generate_orderedappend_paths with aggregate pushdown
2025-11-04T10:02:18Z Re: Teaching planner to short-circuit empty UNION/EXCEPT/INTERSECT inputs
2025-11-04T09:19:34Z Re: Teaching planner to short-circuit empty UNION/EXCEPT/INTERSECT inputs
2025-11-04T07:44:42Z Re: BUG #19102: Assertion failure in generate_orderedappend_paths with aggregate pushdown