From: Scott Marlowe <scott.marlowe@gmail.com>
To: Jason Lustig <lustig@brandeis.edu>
Cc: Richard Huxton <dev@archonet.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Autovacuum running out of memory
Date: Tue, 16 Oct 2007 09:08:20 -0500
Message-ID: <dcc563d10710160708t5e874f6enfde031fc35cee2fd@mail.gmail.com> (raw)
In-Reply-To: <57031F92-40D5-4832-8B76-FB73E510C735@brandeis.edu>
References: <374EB3D1-EE74-4B8C-9EEC-104ADD097568@brandeis.edu>
<4714A458.5060408@archonet.com>
<E8328FA1-800E-4684-93D2-A1002BB72396@brandeis.edu>
<4714AD30.6000103@archonet.com>
<57031F92-40D5-4832-8B76-FB73E510C735@brandeis.edu>
On 10/16/07, Jason Lustig <lustig@brandeis.edu> 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: scott.marlowe@gmail.com, lustig@brandeis.edu, dev@archonet.com
Subject: Re: Autovacuum running out of memory
In-Reply-To: <dcc563d10710160708t5e874f6enfde031fc35cee2fd@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox