First its bad style to use a generic subject like "Question". Use
something related to the specific problem. "Help" is an other poor
Second you need to put in a lot more information about your setup. As an
absolute minimum provide postgresql release and operating system.
Third it sounds like you've got some reading to do. The manual and this
book would be a good place to start:
While you read you should run the command "vacuum analyze", this is
going to take a REALLY LONG time. 12 to 24 hours wouldn't surprise me.
But at least the base will still be online although with degraded
When you've got a better handle on thing I suggest you do a pg_dumpall,
drop the base and perform a restore.
You are likely to run on a more or less outdated version so while doing
the dump and restore you should consider upgrading to the latest
version. The INSTALL document in the source distro tells how to perform
dump/restore when upgrading.
I'm able to do a dump of a 50Gig base in one hour but the restore time
depends a lot on what sort of index'es you have. Don't hold your breath
waiting. All this depends a lot on what sort of hardware you have.
>>> <FBaron(at)co(dot)belcorp(dot)biz> 23-02-05 17:11 >>>
Hi, I have a database with 100 GB size, I never have done a vacuumdb
it, analizyng, there is a table witn almost 25 GB, I have to run a
to clean it.. This is a longer operation.
But somebody said me that if I make a backup(pg_dump), drop the
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.
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2005-02-23 18:12:53|
|Subject: Re: Lingering Checkpoint Process |
|Previous:||From: Tomeh, Husam||Date: 2005-02-23 18:06:08|
|Subject: Partitioning Option?|