From: Tom Lane <tgl@sss.pgh.pa.us>
To: Abu Mushayeed <amushayeed@hotmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Out of memory error
Date: Fri, 23 Jun 2006 13:18:18 -0400
Message-ID: <16806.1151083098@sss.pgh.pa.us> (raw)
In-Reply-To: <BAY108-F1592128391F9565D6C839D17A0@phx.gbl>
References: <BAY108-F1592128391F9565D6C839D17A0@phx.gbl>
"Abu Mushayeed" <amushayeed@hotmail.com> writes:
> AFTER A WHILE THE SYSTEM COMES BACK AND SAYS IN THE LOG FILE:
Please turn off your caps lock key :-(
> AggContext: -1501569024 total in 351 blocks; 69904 free (507 chunks);
> -1501638928 used
> DynaHashTable: 302047256 total in 46 blocks; 275720 free (66 chunks);
> 301771536 used
Hm, it's evidently misjudging how much memory will be needed by a
HashAggregate plan, probably because it's underestimating the number
of GROUP BY groups. Could we see the EXPLAIN output for the query?
What PG version is this exactly? Have you ANALYZEd the table lately?
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, amushayeed@hotmail.com
Subject: Re: Out of memory error
In-Reply-To: <16806.1151083098@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox