Message-ID: <46D86103.6060204@livedatagroup.com>
Date: Fri, 31 Aug 2007 14:42:11 -0400
From: Pallav Kalva <pkalva@livedatagroup.com>
User-Agent: Thunderbird 2.0.0.6 (X11/20070728)
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
CC: Mark Lewis <mark.lewis@mir3.com>
Subject: Re: 8.2 Autovacuum BUG ?
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>
In-Reply-To: <1188577771.22730.238.camel@archimedes>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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
>