From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: ERROR: Memory exhausted in AllocSetAlloc(188) |
Date: | 2003-05-17 03:29:10 |
Message-ID: | 20030517032908.GA3336@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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(at)svana(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2003-05-17 03:30:14 | Re: Heterogeneous service (like Oracle or Ms SQL Server) |
Previous Message | Avi Schwartz | 2003-05-17 02:42:03 | Re: Result set return to Coldfusion MX? |
From | Date | Subject | |
---|---|---|---|
Next Message | Dann Corbit | 2003-05-17 03:35:12 | Re: Error message style guide, take 2 {just for ideas to kick around...} |
Previous Message | Tom Lane | 2003-05-17 03:26:02 | Re: Error message style guide, take 2 {just for ideas to kick around...} |