consulta sobre performance de postgres

[Alvaro Herrera]

On Mon, May 10, 2004 at 01:16:00PM +0200, Fernando San Martin Woerner wrote:
> El lun, 10-05-2004 a las 18:39, Pablo Silva escribió:
> > Estimados:
> > 
> >   Un desarrollador consulta lo siguiente:
> > 
> >   Es posible usar la opcion de autovacuum en
> > postgresql 7.3?
> 
> 
> algo como decirle a cron que lo haga cada cierto tiempo?, para 7.3
> debería ser así, por lo que entiendo, autovacuum viene para la 7.4

http://developer.postgresql.org/cvsweb.cgi/pgsql-server/contrib/pg_autovacuum/README.pg_autovacuum?rev=1.7&content-type=text/x-cvsweb-markup

Cito de ahi:

As of postgresql v7.4 pg_autovacuum is included in the main source
tree under contrib.  Therefore you merely need to "make && make
install" (similar to most other contrib modules) and it will be
installed for you.

If you are using an earlier version of PostgreSQL, uncompress the
tar.gz file into the contrib directory and modify the contrib/Makefile
to include the pg_autovacuum directory.  pg_autovacuum will then be
built as part of the standard postgresql install.  It is known to work
with v7.3 releases; it is not presently compatible with v7.2.

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"El sabio habla porque tiene algo que decir;
el tonto, porque tiene que decir algo" (Platon).