| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Rajesh Kumar Mallah <mallah(at)trade-india(dot)com> |
| Cc: | PostgResql SQL Mailing List <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: abnormal size of the on-disk file. |
| Date: | 2002-04-29 16:46:59 |
| Message-ID: | 20020429094521.G58196-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Fri, 26 Apr 2002, Rajesh Kumar Mallah wrote:
> Hi There,
>
> I have a small table companies (< 300 rows) and its on-disk size shows
> abnormal
If you've been making modifications to the table rows and haven't been
vacuuming you're going to have all the dead rows in the table as well
as live ones. On 7.2 you'd need a vacuum full to clear the space at this
point (you can use normal vacuum more frequently during normal operation
to avoid needing the full).
> does unvaccuming makes tables x2000 times largers??
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Frank Morton | 2002-04-29 23:08:34 | convert from sybase to postgresql |
| Previous Message | Joseph Barillari | 2002-04-29 16:19:21 | Re: Casting dates |