On Wed, 02 Feb 2005 12:13:59 -0500, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Lonni J Friedman <netllama@xxxxxxxxx> writes: > > Although, looking in the log postgresql is generating, I'm seeing the > > following at the same time as that OOM above so it certainly looks > > like the DB is barfing: > > OK, then it's a backend issue not a client-side issue. > > > HashBatchContext: -1934683632 total in 295 blocks; 135760 free (879 > > chunks); -1934819392 used > > Hmm, looks like a hash join ran out of memory. What PG version is this > again, and what do you have sort_mem set to? Can you show an EXPLAIN > for the query that is failing like this? This is PostgreSQL-7.4.6 running on RHES-3 (using the RPMs). sort_mem=100000 I've attached the explain for the query that is blowing up. Thanks for looking at this. -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ L. Friedman netllama@xxxxxxxxx LlamaLand http://netllama.linux-sxs.org
Attachment:
oom.out
Description: Binary data
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
