Re: Out of memory error on select - Mailing list pgsql-general

Werner Bohl <WernerBohl@infutor.com> writes:

> Explain output:
> "HashAggregate  (cost=881509.02..881510.02 rows=200 width=20)"
> "  Filter: (count(*) > 1)"
> "  ->  Seq Scan on lssi_base  (cost=0.00..872950.68 rows=1711668
> width=20)"

If this is just a one-time query just do

set enable_hashagg = off

then run your query.

--
greg