Re: Out of memory on SELECT in 8.3.5

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Matt Magoffin <postgresql(dot)org(at)msqr(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: Out of memory on SELECT in 8.3.5
Date: 2009-02-09 07:14:56
Message-ID: 20090209071456.GC8123@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* Tom Lane (tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-02-09 07:31:40 Re: Out of memory on SELECT in 8.3.5
Previous Message Stephen Frost 2009-02-09 07:12:17 Re: Out of memory on SELECT in 8.3.5