hm. I've been having the same problems when I try to do large postgres operations like index on my Ubuntu instance. I'd figured my configuration was messed up somehow. I'm really glad I came across this information!