Re: ERROR: Memory exhausted in AllocSetAlloc(188) - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: ERROR: Memory exhausted in AllocSetAlloc(188)
Date
Msg-id 20030517032908.GA3336@svana.org
Whole thread Raw
In response to ERROR: Memory exhausted in AllocSetAlloc(188)  (Tilo Schwarz <mail.at.tilo.minus.schwarz.dot.de@remove_last_at.postgresql.org>)
Responses Re: ERROR: Memory exhausted in AllocSetAlloc(188)  ("Jim C. Nasby" <jim@nasby.net>)
Re: ERROR: Memory exhausted in AllocSetAlloc(188)  (Tilo Schwarz <mail@tilo-schwarz.de>)
List pgsql-general
On Sun, May 11, 2003 at 06:21:28PM +0200, Tilo Schwarz wrote:
> Dear Postgresql gurus,
>
> I have a problem (7.3.1 on linux) with a query eating all my memory. First it
> take 2G RAM and then 2G swap. Now I saw, that 7.3.2 addresses some memory
> issues, could my problem solved by upgrading to 7.3.2?
>
> Thanks a lot, description follows
>
>     Tilo
>
> (the query involves a table with 33925848 rows, but only a few thousand rows
> should be returned)

Please send the definition of the view and of your tables.

I couldn't immediatly puzzle out your reply email address so you'll just
have to read this in the archive.

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> "the West won the world not by the superiority of its ideas or values or
> religion but rather by its superiority in applying organized violence.
> Westerners often forget this fact, non-Westerners never do."
>   - Samuel P. Huntington

Attachment

pgsql-general by date:

Previous
From: Avi Schwartz
Date:
Subject: Re: Result set return to Coldfusion MX?
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Heterogeneous service (like Oracle or Ms SQL Server)