From: Pallav Kalva <pkalva@livedatagroup.com>
To: pgsql-performance@postgresql.org
Cc: Mark Lewis <mark.lewis@mir3.com>
Subject: Re: 8.2 Autovacuum BUG ?
Date: Fri, 31 Aug 2007 14:42:11 -0400
Message-ID: <46D86103.6060204@livedatagroup.com> (raw)
In-Reply-To: <1188577771.22730.238.camel@archimedes>
References: <46D83427.60001@livedatagroup.com>
<25038.1188574775@sss.pgh.pa.us>
<46D83C50.3040409@livedatagroup.com>
<20070831161158.GD8046@alvh.no-ip.org>
<46D840EC.1060302@livedatagroup.com>
<1188577771.22730.238.camel@archimedes>
Mark Lewis wrote:
> On Fri, 2007-08-31 at 12:25 -0400, Pallav Kalva wrote:
>
>> Can you please correct me if I am wrong, I want to understand how this
>> works.
>> Based on what you said, it will run autovacuum again when it passes 200M
>> transactions, as SELECTS are transactions too and are going on these
>> tables.
>> But the next time when it runs autovacuum, it shouldnt freeze the tuples
>> again as they are already frozen and wont generate lot of archive logs ?
>> Or is this because of it ran autovacuum for the first time on this db ?
>> just the first time it does this process ?
>>
>
> That is correct. The tuples are now frozen, which means that they will
> not need to be frozen ever again unless you insert/update any records.
>
>
My main concern is filling up my disk with archive logs, so from all the
replies I get is that since tuples are already frozen, next time when it
runs autovacuum it wont generate any archive logs.
Is my assumption right ?
Thanks! everybody on all your replies. It's was very helpful.
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
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: pkalva@livedatagroup.com, mark.lewis@mir3.com
Subject: Re: 8.2 Autovacuum BUG ?
In-Reply-To: <46D86103.6060204@livedatagroup.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