[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Out of memory error, FreeBSD 6.2, PostgreSQL 8.2.4
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2007-08-31 14:14:32
Message-ID: 23422.1188569672 () sss ! pgh ! pa ! us
[Download RAW message or body]

"Joost Kraaijeveld" <J.Kraaijeveld@Askesis.nl> writes:
> I have a query that has run on 3 other *identical* machines (hardware,
> software, postgresql.conf idenntical, just other data in the database)
> that give me an "out of memory error" every time I try (see below).

> Anyone any idea of where or how to look for the problem or the
> solution? 

What have you got work_mem set to?

The problem evidently is that a hash join table has gotten too large:

> HashBatchContext: 533741652 total in 76 blocks; 1376 free (74 chunks); 533740276 used

Now that's supposed to not get bigger than work_mem (plus or minus some
slop), so either you're trying to run with work_mem of half a gig or
more (answer: don't do that) or you've found some kind of memory leak
(answer: send a reproducible test case to pgsql-bugs).

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match
[prev in list] [next in list] [prev in thread] [next in thread]