| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Daniel ?erud <zilch(at)home(dot)se> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Tables grow in size when issuing UPDATEs! Why?? |
| Date: | 2001-03-28 20:03:17 |
| Message-ID: | Pine.BSF.4.21.0103281200420.75849-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 28 Mar 2001, Daniel ?erud wrote:
> Hi,
> I have noticed a strange thing when dealing with postgreSQL.
>
> Foreword: this is all about postgres tables increasing in
> size extremely fast when doing updates. My sainness is
> decreasing in approximatly the same speed. Please look.
>
> ...
>
> 10 times is enough for it to get 16k big. I realised that it
> increases in size EXTREMELY fast when only UDPATing. I find
> this strange, as I update timestamp in my real database
> often and in 5 minutes it is 2 megabytes big and containing
> only 18 rows! (NO BULLSHIT!!)
>
> Please help me with this I am quite desperate...
Postgres uses a non-overwriting storage manager. You are going
to want to vacuum the table regularly to cut the table back
to just rows that are visible.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc Wrubleski | 2001-03-28 20:55:37 | enable pl/pgsql in postgres from postgres-server-7.0.3-2 RPM |
| Previous Message | Ron Peterson | 2001-03-28 19:30:10 | Re: how to load a sql-file???? |