Re: What popular, large commercial websites run

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              |
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+