public inbox for [email protected]help / color / mirror / Atom feed
Messages from [email protected] Re: Reduce LEFT/FULL JOIN to ANTI JOIN in more cases 2026-06-10 07:25 UTC Richard Guo <[email protected]> Re: Reduce LEFT/FULL JOIN to ANTI JOIN in more cases 2026-06-05 07:50 UTC Richard Guo <[email protected]> Reduce LEFT/FULL JOIN to ANTI JOIN in more cases 2026-06-05 02:55 UTC Richard Guo <[email protected]> Re: Eager aggregation, take 3 2026-06-03 01:25 UTC Richard Guo <[email protected]> Re: Wrong unsafe-flag test in check_output_expressions() 2026-06-03 00:51 UTC Richard Guo <[email protected]> Re: Wrong unsafe-flag test in check_output_expressions() 2026-06-02 22:13 UTC Richard Guo <[email protected]> Wrong unsafe-flag test in check_output_expressions() 2026-06-01 08:27 UTC Richard Guo <[email protected]> Re: Eager aggregation, take 3 2026-06-01 07:19 UTC Richard Guo <[email protected]> Re: Fix HAVING-to-WHERE pushdown with mismatched operator families 2026-05-28 09:11 UTC Richard Guo <[email protected]> Re: Fix HAVING-to-WHERE pushdown with mismatched operator families 2026-05-26 23:04 UTC Richard Guo <[email protected]> Fix HAVING-to-WHERE pushdown with mismatched operator families 2026-05-26 08:48 UTC Richard Guo <[email protected]> Re: Remove inner joins based on foreign keys 2026-05-25 21:01 UTC Richard Guo <[email protected]> Re: The bogus calls in remove_self_join_rel() 2026-04-23 07:58 UTC Richard Guo <[email protected]> The bogus calls in remove_self_join_rel() 2026-04-23 02:45 UTC Richard Guo <[email protected]> Re: Bug: Rule actions see wrong values for generated columns (NEW.gen reads OLD value) 2026-04-21 06:05 UTC Richard Guo <[email protected]> Re: Clean up remove_rel_from_query() after self-join elimination commit 2026-04-20 08:17 UTC Richard Guo <[email protected]> Re: Bug: Rule actions see wrong values for generated columns (NEW.gen reads OLD value) 2026-04-20 07:29 UTC Richard Guo <[email protected]> Re: Bug: Rule actions see wrong values for generated columns (NEW.gen reads OLD value) 2026-04-20 05:25 UTC Richard Guo <[email protected]> Re: Clean up remove_rel_from_query() after self-join elimination commit 2026-04-18 10:17 UTC Richard Guo <[email protected]> Re: var_is_nonnullable() fails to handle invalid NOT NULL constraints 2026-04-15 00:51 UTC Richard Guo <[email protected]> Re: Propagate stadistinct through GROUP BY/DISTINCT in subqueries and CTEs 2026-04-14 06:11 UTC Richard Guo <[email protected]> Re: Bug: Rule actions see wrong values for generated columns (NEW.gen reads OLD value) 2026-04-14 03:27 UTC Richard Guo <[email protected]> Re: Bug: Rule actions see wrong values for generated columns (NEW.gen reads OLD value) 2026-04-13 08:30 UTC Richard Guo <[email protected]> Re: Bug: Rule actions see wrong values for generated columns (NEW.gen reads OLD value) 2026-04-13 08:20 UTC Richard Guo <[email protected]> Re: Bug: Rule actions see wrong values for generated columns (NEW.gen reads OLD value) 2026-04-13 02:35 UTC Richard Guo <[email protected]> Propagate stadistinct through GROUP BY/DISTINCT in subqueries and CTEs 2026-04-13 01:18 UTC Richard Guo <[email protected]> Re: pg17: XX000: no relation entry for relid 0 2026-04-11 07:57 UTC Richard Guo <[email protected]> Re: pg17: XX000: no relation entry for relid 0 2026-04-10 14:38 UTC Richard Guo <[email protected]> var_is_nonnullable() fails to handle invalid NOT NULL constraints 2026-04-10 08:48 UTC Richard Guo <[email protected]> Re: Bug: var_is_nonnullable() gives wrong results for old/new in RETURNING 2026-04-10 06:58 UTC Richard Guo <[email protected]> Re: Bug: var_is_nonnullable() gives wrong results for old/new in RETURNING 2026-04-10 05:48 UTC Richard Guo <[email protected]> Re: Potential partition pruning regression on PostgreSQL 18 2026-04-09 08:05 UTC Richard Guo <[email protected]> Re: Potential partition pruning regression on PostgreSQL 18 2026-04-07 08:00 UTC Richard Guo <[email protected]> Clean up remove_rel_from_query() after self-join elimination commit 2026-04-06 08:11 UTC Richard Guo <[email protected]> Re: Asynchronous MergeAppend 2026-04-06 03:40 UTC Richard Guo <[email protected]> Re: Eager aggregation, take 3 2026-04-06 03:06 UTC Richard Guo <[email protected]> Re: Potential partition pruning regression on PostgreSQL 18 2026-04-02 07:34 UTC Richard Guo <[email protected]> Re: Eager aggregation, take 3 2026-03-30 03:17 UTC Richard Guo <[email protected]> Re: Convert ALL SubLinks to ANY SubLinks 2026-03-25 07:43 UTC Richard Guo <[email protected]> Re: Convert NOT IN sublinks to anti-joins when safe 2026-03-12 02:14 UTC Richard Guo <[email protected]> Re: Convert NOT IN sublinks to anti-joins when safe 2026-03-09 04:01 UTC Richard Guo <[email protected]> Re: Convert NOT IN sublinks to anti-joins when safe 2026-03-08 08:16 UTC Richard Guo <[email protected]> Re: Convert NOT IN sublinks to anti-joins when safe 2026-03-04 09:52 UTC Richard Guo <[email protected]> Re: Convert NOT IN sublinks to anti-joins when safe 2026-03-04 09:33 UTC Richard Guo <[email protected]> Re: Convert ALL SubLinks to ANY SubLinks 2026-02-27 01:42 UTC Richard Guo <[email protected]> Convert ALL SubLinks to ANY SubLinks 2026-02-26 07:11 UTC Richard Guo <[email protected]> Re: Consider low startup cost in add_partial_path 2026-02-25 06:35 UTC Richard Guo <[email protected]> Re: Wrong results with grouping sets 2026-02-25 02:26 UTC Richard Guo <[email protected]> Re: Wrong results with grouping sets 2026-02-24 08:10 UTC Richard Guo <[email protected]> Remove obsolete SAMESIGN macro 2026-02-19 08:40 UTC Richard Guo <[email protected]> Redundant restriction checks in apply_child_basequals 2026-02-19 07:36 UTC Richard Guo <[email protected]> Re: Consider low startup cost in add_partial_path 2026-02-17 07:44 UTC Richard Guo <[email protected]> Re: Convert NOT IN sublinks to anti-joins when safe 2026-02-14 07:37 UTC Richard Guo <[email protected]> Re: Planner : anti-join on left joins 2026-02-12 06:42 UTC Richard Guo <[email protected]> Re: Optimize IS DISTINCT FROM with non-nullable inputs 2026-02-10 02:07 UTC Richard Guo <[email protected]> Re: Convert NOT IN sublinks to anti-joins when safe 2026-02-09 07:43 UTC Richard Guo <[email protected]> Re: Optimize IS DISTINCT FROM with non-nullable inputs 2026-02-09 07:08 UTC Richard Guo <[email protected]> Re: Convert NOT IN sublinks to anti-joins when safe 2026-02-05 06:51 UTC Richard Guo <[email protected]> Re: Convert NOT IN sublinks to anti-joins when safe 2026-02-05 06:09 UTC Richard Guo <[email protected]> Re: Convert NOT IN sublinks to anti-joins when safe 2026-02-04 09:47 UTC Richard Guo <[email protected]> Convert NOT IN sublinks to anti-joins when safe 2026-02-03 07:12 UTC Richard Guo <[email protected]> Re: pg_plan_advice 2026-01-29 06:44 UTC Richard Guo <[email protected]> Re: Optimize IS DISTINCT FROM with non-nullable inputs 2026-01-28 06:42 UTC Richard Guo <[email protected]> Re: Optimize IS DISTINCT FROM with non-nullable inputs 2026-01-27 07:10 UTC Richard Guo <[email protected]> Re: Optimize IS DISTINCT FROM with non-nullable inputs 2026-01-26 08:00 UTC Richard Guo <[email protected]> Optimize IS DISTINCT FROM with non-nullable inputs 2026-01-23 13:40 UTC Richard Guo <[email protected]> Re: Remove no-op pull_var_clause flag 2026-01-22 01:45 UTC Richard Guo <[email protected]> Re: Remove no-op PlaceHolderVars 2026-01-21 08:18 UTC Richard Guo <[email protected]> Re: Fwd: pg18 bug? SELECT query doesn't work 2026-01-19 02:39 UTC Richard Guo <[email protected]> Re: Remove no-op PlaceHolderVars 2026-01-16 06:21 UTC Richard Guo <[email protected]> Re: Fwd: pg18 bug? SELECT query doesn't work 2026-01-16 03:27 UTC Richard Guo <[email protected]> Re: Remove no-op PlaceHolderVars 2026-01-16 02:49 UTC Richard Guo <[email protected]> Re: Fwd: pg18 bug? SELECT query doesn't work 2026-01-09 09:52 UTC Richard Guo <[email protected]> Re: Fwd: pg18 bug? SELECT query doesn't work 2026-01-08 13:30 UTC Richard Guo <[email protected]> Re: Fwd: pg18 bug? SELECT query doesn't work 2026-01-08 03:23 UTC Richard Guo <[email protected]> Re: Fwd: pg18 bug? SELECT query doesn't work 2026-01-07 07:31 UTC Richard Guo <[email protected]> Fwd: pg18 bug? SELECT query doesn't work 2026-01-07 02:26 UTC Richard Guo <[email protected]> Re: Planner : anti-join on left joins 2026-01-06 08:23 UTC Richard Guo <[email protected]> Re: Planner : anti-join on left joins 2026-01-05 13:25 UTC Richard Guo <[email protected]> Re: Correction of RowMark Removal During Sel-Join Elimination 2026-01-05 01:31 UTC Richard Guo <[email protected]> Re: pgsql: Ignore PlaceHolderVars when looking up statistics 2026-01-05 00:52 UTC Richard Guo <[email protected]> Re: Some optimizations for COALESCE expressions during constant folding 2025-12-24 10:05 UTC Richard Guo <[email protected]> Re: Some optimizations for COALESCE expressions during constant folding 2025-12-12 02:17 UTC Richard Guo <[email protected]> Re: Issue with query_is_distinct_for() and grouping sets 2025-12-10 02:17 UTC Richard Guo <[email protected]> Re: apply_scanjoin_target_to_paths and partitionwise join 2025-12-04 02:53 UTC Richard Guo <[email protected]> Re: Some optimizations for COALESCE expressions during constant folding 2025-12-03 06:39 UTC Richard Guo <[email protected]> Re: apply_scanjoin_target_to_paths and partitionwise join 2025-12-02 02:15 UTC Richard Guo <[email protected]> Re: Some optimizations for COALESCE expressions during constant folding 2025-12-01 08:11 UTC Richard Guo <[email protected]> Re: Some optimizations for COALESCE expressions during constant folding 2025-11-26 11:55 UTC Richard Guo <[email protected]> Re: Some optimizations for COALESCE expressions during constant folding 2025-11-26 06:33 UTC Richard Guo <[email protected]> Some optimizations for COALESCE expressions during constant folding 2025-11-25 10:50 UTC Richard Guo <[email protected]> Re: Fix typos in ExecChooseHashTableSize() 2025-11-19 02:18 UTC Richard Guo <[email protected]> Re: Use exact nullingrels matches for NestLoopParams 2025-11-17 07:28 UTC Richard Guo <[email protected]> Use exact nullingrels matches for NestLoopParams 2025-11-11 06:58 UTC Richard Guo <[email protected]> Re: Fix comments for ChangeVarNodes() and related functions 2025-11-05 03:47 UTC Richard Guo <[email protected]> Re: Teaching planner to short-circuit empty UNION/EXCEPT/INTERSECT inputs 2025-11-04 10:02 UTC Richard Guo <[email protected]> Re: Teaching planner to short-circuit empty UNION/EXCEPT/INTERSECT inputs 2025-11-04 09:19 UTC Richard Guo <[email protected]> Re: apply_scanjoin_target_to_paths and partitionwise join 2025-10-31 12:20 UTC Richard Guo <[email protected]> Re: apply_scanjoin_target_to_paths and partitionwise join 2025-10-31 06:02 UTC Richard Guo <[email protected]> Re: apply_scanjoin_target_to_paths and partitionwise join 2025-10-29 09:21 UTC Richard Guo <[email protected]> Fix comments for ChangeVarNodes() and related functions 2025-10-23 08:59 UTC Richard Guo <[email protected]> Re: Issue with query_is_distinct_for() and grouping sets 2025-10-23 07:07 UTC Richard Guo <[email protected]> Re: Issue with query_is_distinct_for() and grouping sets 2025-10-23 03:43 UTC Richard Guo <[email protected]> Re: Issue with query_is_distinct_for() and grouping sets 2025-10-23 02:44 UTC Richard Guo <[email protected]> Issue with query_is_distinct_for() and grouping sets 2025-10-22 09:25 UTC Richard Guo <[email protected]> Re: Inconsistent Behavior of GROUP BY ROLLUP in v17 vs master 2025-10-21 05:26 UTC Richard Guo <[email protected]> Re: Inconsistent Behavior of GROUP BY ROLLUP in v17 vs master 2025-10-21 04:12 UTC Richard Guo <[email protected]> Re: Inconsistent Behavior of GROUP BY ROLLUP in v17 vs master 2025-10-21 03:58 UTC Richard Guo <[email protected]> Re: Inconsistent Behavior of GROUP BY ROLLUP in v17 vs master 2025-10-21 03:16 UTC Richard Guo <[email protected]> Re: Inconsistent Behavior of GROUP BY ROLLUP in v17 vs master 2025-10-20 13:32 UTC Richard Guo <[email protected]> Re: Fix an unnecessary cast calling elog in ExecHashJoinImpl 2025-10-16 09:53 UTC Richard Guo <[email protected]> Re: Inconsistent Behavior of GROUP BY ROLLUP in v17 vs master 2025-10-16 09:13 UTC Richard Guo <[email protected]> Re: MergeAppend could consider sorting cheapest child path 2025-10-15 06:45 UTC Richard Guo <[email protected]> Re: A tidyup of pathkeys.c 2025-10-14 08:04 UTC Richard Guo <[email protected]> Why has_useful_pathkeys() needs to check group_pathkeys 2025-10-09 09:36 UTC Richard Guo <[email protected]> Re: Eager aggregation, take 3 2025-10-09 08:07 UTC Richard Guo <[email protected]> Re: Eager aggregation, take 3 2025-10-09 07:01 UTC Richard Guo <[email protected]> Re: Eager aggregation, take 3 2025-10-09 03:10 UTC Richard Guo <[email protected]> Re: plan shape work 2025-10-09 02:24 UTC Richard Guo <[email protected]> Re: Eager aggregation, take 3 2025-10-09 01:51 UTC Richard Guo <[email protected]> Re: Eager aggregation, take 3 2025-10-09 01:49 UTC Richard Guo <[email protected]> Re: Eager aggregation, take 3 2025-10-09 01:48 UTC Richard Guo <[email protected]> Re: Eager aggregation, take 3 2025-10-07 10:56 UTC Richard Guo <[email protected]> Re: Eager aggregation, take 3 2025-10-06 00:59 UTC Richard Guo <[email protected]> Re: Eager aggregation, take 3 2025-10-06 00:56 UTC Richard Guo <[email protected]> Re: Fix incorrect function reference BufFileOpenShared in comment. 2025-10-03 07:41 UTC Richard Guo <[email protected]> Re: MergeAppend could consider sorting cheapest child path 2025-10-03 07:05 UTC Richard Guo <[email protected]> Re: Eager aggregation, take 3 2025-10-03 03:14 UTC Richard Guo <[email protected]> Re: Eager aggregation, take 3 2025-10-02 08:49 UTC Richard Guo <[email protected]> Re: Eager aggregation, take 3 2025-10-02 01:39 UTC Richard Guo <[email protected]> Re: Eager aggregation, take 3 2025-10-02 01:13 UTC Richard Guo <[email protected]> Re: Fix incorrect function reference BufFileOpenShared in comment. 2025-10-01 09:29 UTC Richard Guo <[email protected]> Allow virtual columns in index expressions or predicate 2025-09-30 09:13 UTC Richard Guo <[email protected]> Re: plan shape work 2025-09-30 01:59 UTC Richard Guo <[email protected]> Re: plan shape work 2025-09-29 08:52 UTC Richard Guo <[email protected]> Re: Eager aggregation, take 3 2025-09-29 02:09 UTC Richard Guo <[email protected]> Re: plan shape work 2025-09-29 01:47 UTC Richard Guo <[email protected]> Re: plan shape work 2025-09-26 06:29 UTC Richard Guo <[email protected]> Re: plan shape work 2025-09-26 02:26 UTC Richard Guo <[email protected]> Re: Inconsistent Behavior of GROUP BY ROLLUP in v17 vs master 2025-09-25 08:27 UTC Richard Guo <[email protected]> Re: Inconsistent Behavior of GROUP BY ROLLUP in v17 vs master 2025-09-25 07:55 UTC Richard Guo <[email protected]> Re: Eager aggregation, take 3 2025-09-25 04:23 UTC Richard Guo <[email protected]> Re: Inconsistent Behavior of GROUP BY ROLLUP in v17 vs master 2025-09-25 01:01 UTC Richard Guo <[email protected]> Re: Inconsistent Behavior of GROUP BY ROLLUP in v17 vs master 2025-09-24 08:18 UTC Richard Guo <[email protected]> Re: Inconsistent Behavior of GROUP BY ROLLUP in v17 vs master 2025-09-24 03:10 UTC Richard Guo <[email protected]> Re: Fix wrong filename in header comment of gin_tuple.h 2025-09-22 00:57 UTC Richard Guo <[email protected]> Re: Fix wrong filename in header comment of gin_tuple.h 2025-09-21 23:59 UTC Richard Guo <[email protected]> Re: [PATCH] Correct RangeTblEntry.join_using_alias comment to reflect field order 2025-09-21 23:55 UTC Richard Guo <[email protected]> Re: plan shape work 2025-09-13 09:02 UTC Richard Guo <[email protected]> Re: plan shape work 2025-09-13 08:46 UTC Richard Guo <[email protected]> Re: Eager aggregation, take 3 2025-09-13 08:27 UTC Richard Guo <[email protected]> Re: Eager aggregation, take 3 2025-09-12 09:34 UTC Richard Guo <[email protected]> Re: Reduce "Var IS [NOT] NULL" quals during constant folding 2025-09-12 02:21 UTC Richard Guo <[email protected]> Re: expand virtual generated columns in get_relation_constraints() 2025-09-11 02:16 UTC Richard Guo <[email protected]> Re: plan shape work 2025-09-10 07:16 UTC Richard Guo <[email protected]> Re: Eager aggregation, take 3 2025-09-09 11:18 UTC Richard Guo <[email protected]> Re: Eager aggregation, take 3 2025-09-09 10:30 UTC Richard Guo <[email protected]> Re: Eager aggregation, take 3 2025-09-09 09:20 UTC Richard Guo <[email protected]> Re: Eager aggregation, take 3 2025-09-09 09:07 UTC Richard Guo <[email protected]> Re: plan shape work 2025-09-09 02:22 UTC Richard Guo <[email protected]> Re: plan shape work 2025-09-08 09:51 UTC Richard Guo <[email protected]> Re: MergeAppend could consider sorting cheapest child path 2025-09-08 08:39 UTC Richard Guo <[email protected]> Re: Reduce "Var IS [NOT] NULL" quals during constant folding 2025-09-08 08:21 UTC Richard Guo <[email protected]> Re: Eager aggregation, take 3 2025-09-05 07:35 UTC Richard Guo <[email protected]> Re: plan shape work 2025-09-04 08:21 UTC Richard Guo <[email protected]> Re: Generate GUC tables from .dat file 2025-09-03 09:39 UTC Richard Guo <[email protected]> Re: Pathify RHS unique-ification for semijoin planning 2025-09-03 09:12 UTC Richard Guo <[email protected]> Re: Pathify RHS unique-ification for semijoin planning 2025-09-02 10:10 UTC Richard Guo <[email protected]> Re: MergeAppend could consider sorting cheapest child path 2025-09-02 01:27 UTC Richard Guo <[email protected]> Re: Eager aggregation, take 3 2025-09-01 01:32 UTC Richard Guo <[email protected]> Re: Correction of RowMark Removal During Sel-Join Elimination 2025-08-31 01:03 UTC Richard Guo <[email protected]> Re: Correction of RowMark Removal During Sel-Join Elimination 2025-08-30 23:51 UTC Richard Guo <[email protected]> Re: Correction of RowMark Removal During Sel-Join Elimination 2025-08-30 23:41 UTC Richard Guo <[email protected]> Re: [BUG] Remove self joins causes 'variable not found in subplan target lists' error 2025-08-29 04:27 UTC Richard Guo <[email protected]> Re: [BUG] Remove self joins causes 'variable not found in subplan target lists' error 2025-08-29 01:22 UTC Richard Guo <[email protected]> Re: [BUG] Remove self joins causes 'variable not found in subplan target lists' error 2025-08-28 06:18 UTC Richard Guo <[email protected]> Re: [BUG] Remove self joins causes 'variable not found in subplan target lists' error 2025-08-27 06:56 UTC Richard Guo <[email protected]> Re: [BUG] Remove self joins causes 'variable not found in subplan target lists' error 2025-08-26 09:50 UTC Richard Guo <[email protected]> Re: [BUG] Remove self joins causes 'variable not found in subplan target lists' error 2025-08-26 09:30 UTC Richard Guo <[email protected]> Re: [BUG] Remove self joins causes 'variable not found in subplan target lists' error 2025-08-25 13:28 UTC Richard Guo <[email protected]> Re: Remove unneeded cast in heap_xlog_lock. 2025-08-22 14:01 UTC Richard Guo <[email protected]> Re: Remove unneeded cast in heap_xlog_lock. 2025-08-22 01:41 UTC Richard Guo <[email protected]> Re: Reduce "Var IS [NOT] NULL" quals during constant folding 2025-08-21 01:07 UTC Richard Guo <[email protected]> Re: Reduce "Var IS [NOT] NULL" quals during constant folding 2025-08-20 01:29 UTC Richard Guo <[email protected]> Re: Pathify RHS unique-ification for semijoin planning 2025-08-19 03:05 UTC Richard Guo <[email protected]> Re: Pathify RHS unique-ification for semijoin planning 2025-08-18 06:07 UTC Richard Guo <[email protected]> Re: Eager aggregation, take 3 2025-08-15 01:41 UTC Richard Guo <[email protected]> Re: Pathify RHS unique-ification for semijoin planning 2025-08-13 03:17 UTC Richard Guo <[email protected]> Re: Pathify RHS unique-ification for semijoin planning 2025-08-13 02:17 UTC Richard Guo <[email protected]> Re: Pathify RHS unique-ification for semijoin planning 2025-08-12 01:43 UTC Richard Guo <[email protected]> Re: Eager aggregation, take 3 2025-08-09 01:32 UTC Richard Guo <[email protected]> Re: Pathify RHS unique-ification for semijoin planning 2025-08-08 01:39 UTC Richard Guo <[email protected]> Re: Eager aggregation, take 3 2025-08-06 07:52 UTC Richard Guo <[email protected]> Re: Pathify RHS unique-ification for semijoin planning 2025-08-04 02:08 UTC Richard Guo <[email protected]> Re: Pathify RHS unique-ification for semijoin planning 2025-08-04 01:55 UTC Richard Guo <[email protected]> Re: Pathify RHS unique-ification for semijoin planning 2025-08-01 01:53 UTC Richard Guo <[email protected]> Re: Pathify RHS unique-ification for semijoin planning 2025-07-31 08:58 UTC Richard Guo <[email protected]> Re: Pathify RHS unique-ification for semijoin planning 2025-07-31 04:08 UTC Richard Guo <[email protected]> Re: Reduce "Var IS [NOT] NULL" quals during constant folding 2025-07-30 07:55 UTC Richard Guo <[email protected]> Re: Reduce "Var IS [NOT] NULL" quals during constant folding 2025-07-30 06:17 UTC Richard Guo <[email protected]> 200+ results
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox