Re: Out of swap space & memory

On Mon, Aug 09, 2004 at 11:33:04AM -0700, Kevin Bartz wrote:
> Hi Lincoln! Thanks for your reply. On the problematic SELECT INTO, EXPLAIN
> says:
>
> test=#
> QUERY PLAN
> ------------------------------------------------------------------
> HashAggregate (cost=42.50..42.50 rows=1000 width=356)
> -> Seq Scan on hp_raw (cost=0.00..20.00 rows=1000 width=356)
> (2 rows)

Maybe a hash aggregate is not a good idea in this case. Try applying
ANALYZE to the table before the SELECT INTO, and EXPLAIN again. Or
execute "SET enable_hashagg TO off" before the SELECT INTO.

Food for thought: do we need to make the HashAggregate code able to save
to disk if the space estimate turns out to be wrong?

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Uno combate cuando es necesario... ¡no cuando está de humor!
El humor es para el ganado, o para hacer el amor, o para tocar el
baliset. No para combatir." (Gurney Halleck)