| From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
|---|---|
| To: | Andy Samuel <andysamuel(at)geocities(dot)com> |
| Cc: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: AW: vacuum |
| Date: | 2001-06-13 11:55:32 |
| Message-ID: | Pine.BSF.4.33.0106130855290.80800-100000@mobile.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
8k ...
On Wed, 13 Jun 2001, Andy Samuel wrote:
> The same question ... how's the size after you vacuum the tables/db ?
>
> > continuous UPDATEs happening to his table, no INSERTs, no DELETEs ... and
> > his tables quicklky grow from a 8k table to 65Meg if there is no vacuum
> > happening every few *hours* ...
>
> TIA
> Andy
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mlw | 2001-06-13 12:35:16 | Indexing on a separate volume |
| Previous Message | Andy Samuel | 2001-06-13 10:49:33 | Re: AW: vacuum |