Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes:
> it looks like that postgresql is actually allocating the memory for the
> hashtable of the HashAggregate which is a bit unexpected for a plain
> EXPLAIN.
Not really. EXPLAIN runs plan setup (ExecutorStart).
regards, tom
While playing around with large work_mem(or in that case a bit insane)
and maintenance_work_mem settings I noticed that EXPLAIN behaves quite
weird:
foo=# set work_mem to 20;
SET
Time: 0.187 ms
foo=# explain select count(*) from testtable2 group by a;
QUERY