Re: Out of memory on SELECT in 8.3.5 - Mailing list pgsql-general

From Stephen Frost
Subject Re: Out of memory on SELECT in 8.3.5
Date
Msg-id 20090209071456.GC8123@tamriel.snowman.net
Whole thread Raw
In response to Re: Out of memory on SELECT in 8.3.5  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> Hmm ... a gig here, a gig there, pretty soon you're talking about real
> memory?  He's got several sorts and hashes that are each taking over
> 100MB according to the memory context dump, so it seems impossible that
> it all fits into a strict 32-bit address space.  There's surely no harm
> in double-checking the executable's file type though.

Argh, it's late and I'm not thinking.  Yeah, I had seen the 100M hashes
and just wasn't thinking clearly.  Sorry for the noise.

    Stephen

Attachment

pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Out of memory on SELECT in 8.3.5
Next
From: Tom Lane
Date:
Subject: Re: Out of memory on SELECT in 8.3.5