Tom Lane <[EMAIL PROTECTED]> wrote: > ITAGAKI Takahiro <[EMAIL PROTECTED]> writes: > > I tested 8.3beta4 with DBT-3 (TPC-H) and found unstable selection of plans. > > Planner randomly selected two types of plans (A, B) when I repeated EXPLAIN. > > Are you sure the statistics weren't changing underneath you (due to > auto-vacuum or auto-analyze)?
Sure. There were no statistic changes. There might be regularity in the plan selection. When I connect to postgres newly, I see plans { A, B, A, A ... }. Then disconnect, re-connect and send the same EXPLAINs, the same pattern was reproduced. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq