Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id EC45F9FB5A4 for ; Tue, 16 Oct 2007 11:08:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 33970-05-2 for ; Tue, 16 Oct 2007 11:08:05 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.169]) by postgresql.org (Postfix) with ESMTP id 897059FB596 for ; Tue, 16 Oct 2007 11:08:22 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id j3so82161ugf for ; Tue, 16 Oct 2007 07:08:21 -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=GiwhLKJs+5yqiV/A6yOGbemXtxh3LscnVuzaiqhV1qM=; b=k/+NSQXOyYNryVGy/lPHj8vzG5IIb/npNDGwtnwjB3sJHu/R8MPhhj5jjt+HnMNNx791fa76VqRWNdlNA+heu6xZpepJNEhfhIEbQ8TNik55rF9EwXseXFCW2nt4ww2/s+w5NIV8CKsi2gOquEe36yXbP9bfwF615qG13ZcQl6k= 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=rmfNlXYoBkveof+0PZTF0U030IIAQdyQsqe5R2XQ1Jbn8nXEGtfA3aLBrRmqk6KeevdEAFe3lw6EWp/vSdDoCLKUvmTjg8MTjomuAhEWksNByuNuiUxgSHOlTv4OE4kW6YYqyp5pUs/cssUjCEJmqU7yciLO69QOpbOCCOp5n80= Received: by 10.66.225.9 with SMTP id x9mr9157352ugg.1192543700797; Tue, 16 Oct 2007 07:08:20 -0700 (PDT) Received: by 10.67.29.6 with HTTP; Tue, 16 Oct 2007 07:08:20 -0700 (PDT) Message-ID: Date: Tue, 16 Oct 2007 09:08:20 -0500 From: "Scott Marlowe" To: "Jason Lustig" Subject: Re: Autovacuum running out of memory Cc: "Richard Huxton" , pgsql-performance@postgresql.org In-Reply-To: <57031F92-40D5-4832-8B76-FB73E510C735@brandeis.edu> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <374EB3D1-EE74-4B8C-9EEC-104ADD097568@brandeis.edu> <4714A458.5060408@archonet.com> <4714AD30.6000103@archonet.com> <57031F92-40D5-4832-8B76-FB73E510C735@brandeis.edu> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/175 X-Sequence-Number: 27197 On 10/16/07, Jason Lustig wrote: > Looking at my free memory (from TOP) I find > > Mem: 2062364k total, 1846696k used, 215668k free, 223324k buffers > Swap: 2104496k total, 160k used, 2104336k free, 928216k cached > > So I don't think that I'm running out of memory total... it seems like it's > continually trying to do it. Is there a reason why Postgres would be doing > something without a username or database? Or is that just how autovacuum > works? You are NOT running out of memory. Look at the size of your cache and buffers, together they add up to over 1 Gig of memory. You've got plenty of free memory. I'm betting you're running postgresql under an account with a ulimit setting on your memory.