Re: Out of memory error on select

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Out of memory error on select
Date: 2005-04-05 21:30:03
Message-ID: 87ekdooqsk.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Werner Bohl <WernerBohl(at)infutor(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2005-04-05 21:46:50 Re: [HACKERS] plPHP in core?
Previous Message Scott Marlowe 2005-04-05 21:17:30 Re: Out of memory error on select