Received: from localhost (unknown [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id EC6249FA0CB
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Tue,  4 Sep 2007 14:33:39 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 90680-04 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Tue,  4 Sep 2007 14:33:31 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from nz-out-0506.google.com (nz-out-0506.google.com
 [64.233.162.239])
	by postgresql.org (Postfix) with ESMTP id 780CE9F9D32
	for <pgsql-performance@postgresql.org>;
	Tue,  4 Sep 2007 14:33:30 -0300 (ADT)
Received: by nz-out-0506.google.com with SMTP id l8so938021nzf
	for <pgsql-performance@postgresql.org>;
	Tue, 04 Sep 2007 10:33:29 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=GBhHhUgc+xN3uqMgBQ3NRHq+hrya0VEHpI2KtsWhHuhLTTtcVy0VYsBLcMZYet4bsUdEx43EXZBeCsATieoeTr20gpjeCqN4/PJigyoG+2211B8/ZUD6yjc0jEPHJOYOxYaDW8I2ixOeemRU7f9dTh9TcUzfdSC2dR3Boh/lHPM=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=LOIXTSYC5XpkTWxtR5ssVj1JzfIWCFbFZQ3CEXPltGK55Vk32TcrHwTcfUfxsnEMjPKmHF7PlzOOnzqpoUgi1g6ngRIMse5lqiDt8BJK4SBdv/JJiEopTrOowXDRkaV5GwYixdSpObTfjGWwAWIyGphVCYxe1/dwxMaFutrPE98=
Received: by 10.64.91.15 with SMTP id o15mr10964052qbb.1188927209274;
	Tue, 04 Sep 2007 10:33:29 -0700 (PDT)
Received: by 10.65.83.8 with HTTP; Tue, 4 Sep 2007 10:33:29 -0700 (PDT)
Message-ID: <2ca799770709041033n664cb0ep3a5679548dac3a2e@mail.gmail.com>
Date: Tue, 4 Sep 2007 20:33:29 +0300
From: "Mikko Partio" <mpartio@gmail.com>
To: "rafael@akyasociados.com.ar" <rafael@akyasociados.com.ar>
Subject: Re: Vacum Analyze problem
Cc: pgsql-performance@postgresql.org
In-Reply-To: 
 <1275.192.168.1.229.1188926827.squirrel@webmail.akyasociados.com.ar>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_29192_26306783.1188927209218"
References: 
 <1275.192.168.1.229.1188926827.squirrel@webmail.akyasociados.com.ar>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200709/20
X-Sequence-Number: 26565

------=_Part_29192_26306783.1188927209218
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 9/4/07, rafael@akyasociados.com.ar <rafael@akyasociados.com.ar> wrote:
>
> Hello everyone:
>
>    I wanted to ask you about how the VACUUM ANALYZE works. is it possible
> that something can happen in order to reset its effects forcing to execute
> the VACUUM ANALYZE comand again?



Yes, lots of modifications (INSERT,UPDATE,DELETE) to the table in question.

Regards

MP

------=_Part_29192_26306783.1188927209218
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<br><br><div><span class="gmail_quote">On 9/4/07, <b class="gmail_sendername"><a href="mailto:rafael@akyasociados.com.ar">rafael@akyasociados.com.ar</a></b> &lt;<a href="mailto:rafael@akyasociados.com.ar">rafael@akyasociados.com.ar
</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hello everyone:<br><br>&nbsp;&nbsp; I wanted to ask you about how the VACUUM ANALYZE works. is it possible
<br>that something can happen in order to reset its effects forcing to execute<br>the VACUUM ANALYZE comand again?</blockquote><div><br><br>Yes, lots of modifications (INSERT,UPDATE,DELETE) to the table in question. <br><br>
Regards<br><br>MP<br></div><br><div><br>&nbsp;<br></div><br></div><br>

------=_Part_29192_26306783.1188927209218--