Re: More harrowing tales of TOAST growth

From: Sean Chittenden <chitt(at)acm(dot)org>
To: Jeffrey Baker <jwbaker(at)acm(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: More harrowing tales of TOAST growth
Date: 2002-05-05 01:50:17
Message-ID: 20020504185017.B61561@ninja1.internal
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> I ran this experiment for 10 minutes. At time 0 the database size
> was 2MB. At 60 seconds the size was 22MB. The size continued
> upward:
>
> Time | Size
> 0 2
> 60 7
> 120 60
> 180 109
> 240 181
> 300 282
> 360 284
> 420 363
> 480 442
> 540 549
> 600 557

This may be outisde of the possibility of your environment, but have
you tried a VACUUM FULL or VACUUM FREEZE ? -sc

--
Sean Chittenden

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Feng-Cheng Chang 2002-05-05 01:58:41 Fatal error after a system crash
Previous Message Jeffrey Baker 2002-05-05 01:10:57 More harrowing tales of TOAST growth