From: Rafael Domiciano <rafael.domiciano@gmail.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Jessica Richard <rjessil@yahoo.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: vacuum full...
Date: Fri, 20 Feb 2009 08:36:48 -0300
Message-ID: <3a0028490902200336ha7b42cv6b87b12fa062378e@mail.gmail.com> (raw)
In-Reply-To: <dcc563d10902191211g73932526l468d9b8bd1c356ad@mail.gmail.com>
References: <255907.92456.qm@web111313.mail.gq1.yahoo.com>
<dcc563d10902190837r3a528793p29b6e2245ce99208@mail.gmail.com>
<3a0028490902191001i2057a5ebs1e77b0f8ebf556bb@mail.gmail.com>
<dcc563d10902191211g73932526l468d9b8bd1c356ad@mail.gmail.com>
I don't have too much delete and update in the middle of the day to run
autovacuum, but in the night, before vacuum analyze, there is some proccess
that does delete and update, then run vacuum analyze.
On Thu, Feb 19, 2009 at 5:11 PM, Scott Marlowe <scott.marlowe@gmail.com>wrote:
> On Thu, Feb 19, 2009 at 11:01 AM, Rafael Domiciano
> <rafael.domiciano@gmail.com> wrote:
> > I used to run vacuum full in one of my bases, but now i'm not running
> > anymore vacuum full, just vacuum analyze in the past 1 month, but the
> number
> > of necessary pages is increasing every day, now it's in 311264... there
> is
> > any problem this get increasing?
> > When I runned Reindex few days ago, this number get not decreased.
> > I now that vacuum full reorders the relation, but it's the only thing
> that
> > it does?
>
> Same question I had for the other poster, why are you not running
> autovacuum? Has it proven itself not up to the task?
>
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-admin@postgresql.org
Cc: rafael.domiciano@gmail.com, scott.marlowe@gmail.com, rjessil@yahoo.com
Subject: Re: vacuum full...
In-Reply-To: <3a0028490902200336ha7b42cv6b87b12fa062378e@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