Michael Fuhr wrote: > Is vacuuming any table supposed to zero the statistics for all > shared tables?
Huh, certainly not. In any case, I think the problem may be related to the fact that stats for shared tables are kept in a separate hash from regular tables. I'll investigate the issue tomorrow -- thanks for reporting. -- Alvaro Herrera http://www.amazon.com/gp/registry/CTMLCN8V17R4 "The Gord often wonders why people threaten never to come back after they've been told never to return" (www.actsofgord.com) ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match