Re: postmaster consuming /lots/ of memory with hash aggregate. why?

On Thu, Nov 11, 2010 at 10:26 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> Hello
>
> look on EXPLAIN ANALYZE command. Probably your statistic are out, and
> then planner can be confused. EXPLAIN ANALYZE statement show it.

As I noted earlier, I did set statistics to 1000 an re-ran vacuum
analyze and the plan did not change.

What other diagnostics can I provide? This still doesn't answer the
40000 row question, though. It seems absurd to me that the planner
would give up and just use 40000 rows (0.02 percent of the actual
result).

--
Jon