Skip site navigation (1) Skip section navigation (2)

Question

From: FBaron(at)co(dot)belcorp(dot)biz
To: pgsql-admin(at)postgresql(dot)org
Subject: Question
Date: 2005-02-23 17:11:02
Message-ID: OFB1A29EC6.B67A0CAA-ON05256FB1.005D61A4-05256FB1.005E5D03@belcorp.biz (view raw or flat)
Thread:
Lists: pgsql-admin



Hi, I have a database with   100 GB size, I never have done a vacuumdb to
it, analizyng,  there is a table witn almost 25 GB, I have to run a Vaccum
to clean it.. This is a longer operation.

But somebody said me that if I make a backup(pg_dump), drop the database,
create db, an then restore again, tha database is cleaned(recover disk
space) and reindexed, is that true?
If is true, how long is this?

Thnaks for your help.

Fabio.




Aviso de confidencialidad:
Este mensaje de correo electrónico contiene información estrictamente
confidencial no susceptible de ser distribuida. Si usted no es el
destinatario de este mensaje, por favor no publicarlo, copiarlo o tomar
cualquier otro tipo de accion sobre esta transmision. Si recibio este
mensaje por error, por favor notifiquenoslo y eliminelo lo antes posible.

Warning of confidentiality:
This message of electronic mail contains strictly confidential information
nonsusceptible to be distributed. If you are not the adressee of this
message, please do not publish it, copy it or take any other kind of action
on this transmission. If you got this message by mistake, please notify it
to us and eliminate it as soon as possible.


pgsql-admin by date

Next:From: Art TaylorDate: 2005-02-23 17:26:50
Subject: unsubscribe
Previous:From: Cory VokeyDate: 2005-02-23 16:28:25
Subject: Lingering Checkpoint Process

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group