From: | "Matt Magoffin" <postgresql(dot)org(at)msqr(dot)us> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "Stephen Frost" <sfrost(at)snowman(dot)net>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Out of memory on SELECT in 8.3.5 |
Date: | 2009-02-09 07:09:53 |
Message-ID: | 51563.192.168.1.106.1234163393.squirrel@msqr.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> 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.
I did reply to this in a different email in this thread, but just to be
safe, yes, I did verify Postgres is a 64-bit binary:
[postgres(at)170226-db7 ~]$ file /opt/lms/postgres-8.3_64/bin/postgres
/opt/lms/postgres-8.3_64/bin/postgres: ELF 64-bit LSB executable, AMD
x86-64, version 1 (SYSV), for GNU/Linux 2.6.9, dynamically linked (uses
shared libs), for GNU/Linux 2.6.9, not stripped
Regards,
Matt
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-02-09 07:10:50 | Re: Out of memory on SELECT in 8.3.5 |
Previous Message | Tom Lane | 2009-02-09 07:06:53 | Re: Out of memory on SELECT in 8.3.5 |