Re: [PERFORM] Trying to understand Stats/Query planner issue

2011-11-13 Thread Tom Lane
"Strange, John W" writes: > I have a question on how the analyzer works in this type of scenario. > We calculate some results and COPY INTO some partitioned tables, which we use > some selects to aggregate the data back out into reports. Everyone once in a > while the aggregation step picks a b

[PERFORM] Trying to understand Stats/Query planner issue

2011-11-13 Thread Strange, John W
I have a question on how the analyzer works in this type of scenario. We calculate some results and COPY INTO some partitioned tables, which we use some selects to aggregate the data back out into reports. Everyone once in a while the aggregation step picks a bad plan due to stats on the tables