| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Tim Perdue <tim(at)perdue(dot)net> |
| Cc: | Maurício Sessue Otta <mauricio(at)cristorei(dot)com(dot)br>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Different size in the DATA directory |
| Date: | 2002-11-02 03:48:00 |
| Message-ID: | 200211020348.gA23m0w10244@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Tim Perdue wrote:
> I had this same problem with 7.1.x, even doing full vacuums on
> SourceForge.net last year.
>
> I assumed after a while that there was some hidden bug where file bloat
> occurred, despite the vacuum. After 3 months or so, you'd have to
> dump/restore the entire db and you'd be golden for a while again. After
> the dump/restore process things seemed much snappier too, and vacuum ran
> almost instantly.
>
> I haven't verified if this problem still occurs in 7.2.x, using vacuum full.
Tim, I guess your problem is dead index pages that can't be reclaimed,
and it isn't fixed in 7.3. Only REINDEX fixes it, and we have a
/contrib/reindexdb script in 7.3.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-11-02 04:07:04 | Re: select syntax question |
| Previous Message | Bruce Momjian | 2002-11-02 01:47:48 | Re: How do I get rid of these messages? |