pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Markus Schaber <schabi@logix-tt.com>
To: postgres performance list <pgsql-performance@postgresql.org>
Subject: Re: Help tuning autovacuum - seeing lots of relationbloat
Date: Fri, 23 Jun 2006 14:40:47 +0200
Message-ID: <449BE14F.3060601@logix-tt.com> (raw)
In-Reply-To: <20060621193823.GI93655@pervasive.com>
References: <200606211052.43227.jody.brownell@q1labs.com>
	<200606211227.06618.jody.brownell@q1labs.com>
	<1150904541.3309.38.camel@coppola.muc.ecircle.de>
	<200606211321.06253.jody.brownell@q1labs.com>
	<20060621193823.GI93655@pervasive.com>

Jim C. Nasby wrote:
> On Wed, Jun 21, 2006 at 01:21:05PM -0300, jody brownell wrote:
>> Jun 21 13:04:04 vanquish postgres[3311]: [19-1] DEBUG:  "target": removed 5645231 row versions in 106508 pages
>> Jun 21 13:04:04 vanquish postgres[3311]: [19-2] DETAIL:  CPU 3.37s/1.23u sec elapsed 40.63 sec.
>> Jun 21 13:04:04 vanquish postgres[3311]: [20-1] DEBUG:  "target": found 5645231 removable, 1296817 nonremovable row versions in 114701 pages
>> Jun 21 13:04:04 vanquish postgres[3311]: [20-2] DETAIL:  0 dead row versions cannot be removed yet.
> 
> So the table contained 5.6M dead rows and 1.3M live rows.
> 
> I think you should forget about having autovacuum keep this table
> in-check and add manual vacuum commands to your code. Autovac is
> intended to deal with 99% of use cases; this is pretty clearly in the 1%
> it can't handle.

Maybe your free space map is configured to small, can you watch out for
log messages telling to increase it?


HTH,
Markus

-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org



view thread (19+ messages)

Message-ID: <449BE14F.3060601@logix-tt.com>
Permalink:  ../449BE14F.3060601@logix-tt.com/
Also on:    postgresql.org/message-id/449BE14F.3060601@logix-tt.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 using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: schabi@logix-tt.com
  Subject: Re: Help tuning autovacuum - seeing lots of relationbloat
  In-Reply-To: <449BE14F.3060601@logix-tt.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