Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 574911337999
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon, 10 Jan 2011 10:21:31 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 61402-05 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon, 10 Jan 2011 14:21:23 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from hermes.vectorsf.com (firewall.vectorsf.com [62.82.80.62])
	by mail.postgresql.org (Postfix) with ESMTP id E9FFB1337B97
	for <pgsql-admin@postgresql.org>; Mon, 10 Jan 2011 10:21:22 -0400 (AST)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by hermes.vectorsf.com (Postfix) with ESMTP id D592611C0174
	for <pgsql-admin@postgresql.org>; Mon, 10 Jan 2011 15:21:19 +0100 (CET)
X-Virus-Scanned: amavisd-new at hermes.vectorsf.com
Received: from hermes.vectorsf.com ([127.0.0.1])
	by localhost (hermes.vectorsf.com [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id NUpPrfUyPp45 for <pgsql-admin@postgresql.org>;
	Mon, 10 Jan 2011 15:21:19 +0100 (CET)
Received: from [10.70.4.200] (unknown [10.70.4.200])
	(Authenticated sender: imartinez)
	by hermes.vectorsf.com (Postfix) with ESMTPSA id 9C08611C0165
	for <pgsql-admin@postgresql.org>; Mon, 10 Jan 2011 15:21:19 +0100 (CET)
Subject: Re: saludos y consulta
From: =?ISO-8859-1?Q?I=F1igo?= Martinez Lasala <imartinez@vectorsf.com>
To: pgsql-admin@postgresql.org
In-Reply-To: <4D276450.3090607@federacion.pasteleros.org.ar>
References: <4D276450.3090607@federacion.pasteleros.org.ar>
Content-Type: multipart/alternative; boundary="=-ZIofFK9/GNDPB0tIGJs/"
Date: Mon, 10 Jan 2011 15:21:21 +0100
Message-ID: <1294669281.9409.42.camel@deimos>
Mime-Version: 1.0
X-Mailer: Evolution 2.30.3 
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.509 tagged_above=-10 required=5 tests=BAYES_50=0.8,
	HTML_MESSAGE=0.001, RCVD_IN_DNSWL_MED=-2.3,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201101/49
X-Sequence-Number: 36489


--=-ZIofFK9/GNDPB0tIGJs/
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 8bit

Hi Alejandro.

Your master server is sending WAL segments to slave server. So, each
server has its own tables.
So, you have to launch an analyze process on both servers in order to
get accurate statistics.

Anyway, it's not desirable to disable autovacuum. Why to you disable it?
If you have a lot of deletes in some tables, you can tune autovacuum to
not hit in your performance, and it's not necessary to launch it
manually.

-----Original Message-----
From: Alejandro Brust at federacion
<alejandrob@federacion.pasteleros.org.ar>
Reply-to: alejandrob@federacion.pasteleros.org.ar
To: pgsql-admin@postgresql.org
Subject: [ADMIN] saludos y consulta
Date: Fri, 07 Jan 2011 16:06:56 -0300


Hola a todos y feliz año!

Mi consulta es la siguiente:
Tengo funcionando OK dos server identicos con PG 9.0.1 y streaming 
replication.
Para un mejor funcionamiento durante la carga de datos deshabilite el 
autovacuum en el master y lo corro todas las noches desde un cron 
(freebsd) pero tengo la siguiente duda, el "vacuum --analize --all" me 
actualiza tambien el el esclavo las estadisticas? o sea
los dos servidores van a tener las mismas estadisticas?

Gracias por adelantado




--=-ZIofFK9/GNDPB0tIGJs/
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
  <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
  <META NAME="GENERATOR" CONTENT="GtkHTML/3.30.3">
</HEAD>
<BODY>
Hi Alejandro.<BR>
<BR>
Your master server is sending WAL segments to slave server. So, each server has its own tables.<BR>
So, you have to launch an analyze process on both servers in order to get accurate statistics.<BR>
<BR>
Anyway, it's not desirable to disable autovacuum. Why to you disable it? If you have a lot of deletes in some tables, you can tune autovacuum to not hit in your performance, and it's not necessary to launch it manually.<BR>
<BR>
-----Original Message-----<BR>
<B>From</B>: Alejandro Brust at federacion &lt;<A HREF="mailto:Alejandro%20Brust%20at%20federacion%20%3calejandrob@federacion.pasteleros.org.ar%3e">alejandrob@federacion.pasteleros.org.ar</A>&gt;<BR>
<B>Reply-to</B>: alejandrob@federacion.pasteleros.org.ar<BR>
<B>To</B>: <A HREF="mailto:pgsql-admin@postgresql.org">pgsql-admin@postgresql.org</A><BR>
<B>Subject</B>: [ADMIN] saludos y consulta<BR>
<B>Date</B>: Fri, 07 Jan 2011 16:06:56 -0300<BR>
<BR>
<PRE>
Hola a todos y feliz a&#241;o!

Mi consulta es la siguiente:
Tengo funcionando OK dos server identicos con PG 9.0.1 y streaming 
replication.
Para un mejor funcionamiento durante la carga de datos deshabilite el 
autovacuum en el master y lo corro todas las noches desde un cron 
(freebsd) pero tengo la siguiente duda, el &quot;vacuum --analize --all&quot; me 
actualiza tambien el el esclavo las estadisticas? o sea
los dos servidores van a tener las mismas estadisticas?

Gracias por adelantado

</PRE>
<BR>
</BODY>
</HTML>

--=-ZIofFK9/GNDPB0tIGJs/--