From: Iñigo Martinez Lasala <imartinez@vectorsf.com>
To: pgsql-admin@postgresql.org
Subject: Re: saludos y consulta
Date: Mon, 10 Jan 2011 15:21:21 +0100
Message-ID: <1294669281.9409.42.camel@deimos> (raw)
In-Reply-To: <4D276450.3090607@federacion.pasteleros.org.ar>
References: <4D276450.3090607@federacion.pasteleros.org.ar>
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
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: imartinez@vectorsf.com
Subject: Re: saludos y consulta
In-Reply-To: <1294669281.9409.42.camel@deimos>
* 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