Re: Script Vacuum

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Ariel Centeno <arielcen(at)hotmail(dot)com>
Cc: pgsql-es-ayuda <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: Re: Script Vacuum
Date: 2010-08-31 15:10:29
Message-ID: 1283267409-sup-8640@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

Excerpts from Ariel Centeno's message of mar ago 31 07:32:55 -0400 2010:
>
> Queria saber si me podian facilitar un script para correr en forma periodica para que realice el vacuum y el reindex de mis bases. Tambien si me pueden aconsejar con que periodicidad conviene realizarlo.

activa autovacuum

--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Marcos Luis Ortiz Valmaseda 2010-08-31 18:32:14 Re: hstore
Previous Message Sergio Gabriel Rodriguez 2010-08-31 13:31:47 Re: Script Vacuum