wenchaozhang-123 commented on PR #733: URL: https://github.com/apache/cloudberry/pull/733#issuecomment-2505220909
> > > > As two directory schema tables have the approximately the same in tuples count, the join plan is unstable. > > > > > > > > > > > > > > Will Analyze make plan stable? > > > > > > Actually not, have added analyze table before executing explain in test case, join plan is still unstable. > > Is it a problem of analyze on directory tables? The plan should be stable after ANALYZE like normal tables, planer only cares about costs. Analyze directory tables means analyze directory tables' schema tables which are just heap tables which is not different at all. What's more, have not changed any codes of directory table in planner. So it's should not be a problem of analyze directory table. I guess maybe the two tables have the same count tuples cause the join plan not stable. Sometimes a join b, othertimes b join a. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
