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.