From: | Leonel Nunez <lnunez(at)enelserver(dot)com> |
---|---|
To: | pop(at)cofradia(dot)org |
Cc: | pgsql-es-ayuda(at)postgresql(dot)org |
Subject: | Re: problema con un Vacuumdb |
Date: | 2004-10-07 16:11:41 |
Message-ID: | 41656ABD.7060905@enelserver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
Fernando Romo wrote:
> al dar un vacuumdb me manda el error que a continuacion pongo. Cabe
> destacar que tengo muchisima memoria y espacio en disco:
>
> vacuumdb -f mybase
>
> vacuumdb: vacuuming of database "monitor_k" failed: PANIC:
> insufficient room in FSM
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> -------
>
> Ahora estoy usando un Postgresql version 7.4.0 y el problema es que la
> tabla principal tiene alrededor de 16,170,000 registros.
>
> Saludos... El Pop
>
vacuum full
echale un ojo a
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
en la seccion de Some less known parameters
--
,''`. Leonel Nunez
: :' : http://enelserver.com
`. `' DEBIAN GNU/LINUX
`-
From | Date | Subject | |
---|---|---|---|
Next Message | FERNANDO MIGUEL NORIEL VILLARROEL | 2004-10-07 17:00:35 | pg_hba.conf |
Previous Message | Fernando Romo | 2004-10-07 15:58:23 | problema con un Vacuumdb |