From: | Shaun Thomas <sthomas(at)townnews(dot)com> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | PostgreSQL general list <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: What popular, large commercial websites run |
Date: | 2002-06-03 15:50:04 |
Message-ID: | Pine.LNX.4.44.0206031044020.1941-100000@hamster.lee.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)townnews(dot)com AIM : trifthen |
| Web : www.townnews.com |
| |
| "Most of our lives are about proving something, either to |
| ourselves or to someone else." |
| -- Anonymous |
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 2002-06-03 16:25:54 | Re: What popular, large commercial websites run |
Previous Message | Matteo Beccati | 2002-06-03 15:29:17 | Re: [PHP] Problems while compiling php_4-2.1 with PostgreSQL |