Postgres Pro
Downloads
Home   >   mailing lists

Re: More harrowing tales of TOAST growth - Mailing list pgsql-general

From Sean Chittenden
Subject Re: More harrowing tales of TOAST growth
Date
Msg-id 20020504185017.B61561@ninja1.internal
Whole thread Raw
In response to More harrowing tales of TOAST growth  (Jeffrey Baker <jwbaker@acm.org>)
List pgsql-general
Tree view 
> 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

pgsql-general by date:

Previous
From: Alan Wayne
Date:
Subject: Re: HOWTO - Random character generation for primary key
Next
From: "Jesus Contreras"
Date:
Subject: [POSTGRESQL] LOCKING A ROW