On Sat, 1 Jun 2002, Bruce Momjian wrote:
> I have read the thread an no one seems to have addressed your problem
> --- that a full vacuum doesn't reduce the db sizes back to 100mb.
Wow, this is an old thread, too. ^_^ Actually, I copied the vacuumdb
script and changed the parameters/code to be a reindex script. I
submitted it five times in various forms until it did basically
everything everyone was requesting. I think I was hinting around that
it should be added to the official codebase because it's a necessary
utility.
Why? Because that made my problem go away. The problem was that vacuum
doesn't reindex, so indexes just kept growing. Either way, there's no
longer a problem. ^_^
Take care.
--
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+
| Shaun M. Thomas INN Database Administrator |
| Phone: (309) 743-0812 Fax : (309) 743-0830 |
| Email: sthomas@townnews.com AIM : trifthen |
| Web : www.townnews.com |
| |
| "Most of our lives are about proving something, either to |
| ourselves or to someone else." |
| -- Anonymous |
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+