Stephen Frost <sfrost@xxxxxxxxxxx> writes: > * Tom Lane (tgl@xxxxxxxxxxxxx) wrote: >> I think it must be compiled 64-bit, or he'd not be able to get >> shared_buffers that high to start with. > I'm not so sure.. He has it as '4000MB', which would leave 96M free, > which doesn't seem that far from where his query is ending up at based > on the memory info he provided and the size of the sorts being done. > The ulimit is certainly something else to check tho. 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. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
