Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 29D409FA442 for ; Fri, 7 Sep 2007 06:01:56 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 68685-02 for ; Fri, 7 Sep 2007 06:01:33 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.190]) by postgresql.org (Postfix) with ESMTP id B37139F9DC2 for ; Fri, 7 Sep 2007 06:01:52 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id 30so357408nfu for ; Fri, 07 Sep 2007 02:01:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=xV7WwxwBbCKUlvGtqucmzOPwsnTNEuksWWRbpKy9LvQ=; b=TF4oLmrmpUQuTvc0vLnqwjUd9eKrHx5zu5Ydz3gXpBNu8/EBr7jppETP3b0weyBWAvA112AHIFY9KA/0aDgNGNv5egyUXxJIYVpzDGgkdNjJVuPQ872qW5iknIHmoUEMfrvI5MEraOFVjKTQCmtA1vsOuqmMLvlk5MupLAigtqM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=AdnHeRbiI0icrw41H/Amwfr3K3XlseOtq0LAPGAhH4dIOVXl52TVTe3rgSDgSBpyrcJMdS0NcVUZQZDBmEoGxqdRUrs6J9xuZWX76CNgp1TP5ddcrHzAnojiJmm0Zk09zNwjWmEplm8oMicCow3etxRJZ6NhJx/cocbeifEe1zc= Received: by 10.78.172.20 with SMTP id u20mr670813hue.1189155707749; Fri, 07 Sep 2007 02:01:47 -0700 (PDT) Received: by 10.78.146.10 with HTTP; Fri, 7 Sep 2007 02:01:47 -0700 (PDT) Message-ID: Date: Fri, 7 Sep 2007 11:01:47 +0200 From: "Claus Guttesen" To: "Richard Yen" Subject: Re: postgres memory management issues? Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/116 X-Sequence-Number: 26661 > I've recently run into problems with my kernel complaining that I ran > out of memory, thus killing off postgres and bringing my app to a > grinding halt. > > I'm on a 32-bit architecture with 16GB of RAM, under Gentoo Linux. > Naturally, I have to set my shmmax to 2GB because the kernel can't > support more (well, I could set it to 3GB, but I use 2GB for safety). Wouldn't it make sense to install an amd64 version with so much RAM? -- regards Claus When lenity and cruelty play for a kingdom, the gentlest gamester is the soonest winner. Shakespeare