From: | Tilo Schwarz <mail(at)tilo-schwarz(dot)de> |
---|---|
To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: ERROR: Memory exhausted in AllocSetAlloc(188) |
Date: | 2003-05-26 18:56:32 |
Message-ID: | 200305262056.32433.mail@tilo-schwarz.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Martijn van Oosterhout writes:
> 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.
To prevent nasty line breaks, I put the definitions in a text file at:
http://www.tilo-schwarz.de/OutOfMem.txt
In the meantime I read Toms' comments regarding the "pending-trigger-call
lists" - does that apply to my problem too (I have just a SELECT)?
Thanks a lot!
Tilo
PS:
> I couldn't immediatly puzzle out your reply email address so you'll just
> have to read this in the archive.
I "encrypted" my mail address (obviously too complicated), because since I
posted a few times on this list, I get about ten times the amount of spam
than I got before.
From | Date | Subject | |
---|---|---|---|
Next Message | Al-Karim Bhamani (LCL) | 2003-05-26 19:09:43 | Re: latin1 -> unicode |
Previous Message | Wayne Armstrong | 2003-05-26 18:50:50 | Re: Slashdot: SAP and MySQL Join Forces |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-05-26 18:59:57 | Re: v7.3.3 bundled ... please test ... |
Previous Message | Bruce Momjian | 2003-05-26 18:55:59 | Re: Removing a user's password |