pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Warren Little <warren.little@meridiascapital.com>
To: pgsql-admin@postgresql.org
Subject: auto vacuum doens't appear to be working
Date: Fri, 30 Jun 2006 08:08:40 -0600
Message-ID: <200606300808.40460.warren.little@meridiascapital.com> (raw)


We have a bytea column where we store large attachments (ie pdf file).
every so often (2 weekly) we replace the large a attachment (5-15mb) with a 
much smaller binary file (15k).  

when I run 
SELECT sum( relpages*8/1024 ) as MB FROM pg_class where relname != '' 
I get a value of 104995 which I interpret to mean I have 104GB of stored data 
in the database and this value has remained relatively static (+/- 1GB) over 
the past couple of weeks. 
We I to a df -h on the filesystem holding the database cluster I get a usage 
of 140GB.  Again I interpret this to mean I have nearly 35GB of "uncleaned" 
data.

Is this a case where I should be running the vacuum manually or is auto vacuum 
all that should be necessary to keep track and mark the updated tuple space 
ready for re-use.

thanks

-- 
Warren Little
Chief Technology Officer
Meridias Capital, Inc
1006 Atherton Dr
Salt Lake City, UT 84123
ph. 866.369.7763



view thread (3+ messages)  latest in thread

Message-ID: <200606300808.40460.warren.little@meridiascapital.com>
Permalink:  ../200606300808.40460.warren.little@meridiascapital.com/
Also on:    postgresql.org/message-id/200606300808.40460.warren.little@meridiascapital.com

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: warren.little@meridiascapital.com
  Subject: Re: auto vacuum doens't appear to be working
  In-Reply-To: <200606300808.40460.warren.little@meridiascapital.com>
  References: <200606300808.40460.warren.little@meridiascapital.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