Re: Toast space grows - Mailing list pgsql-performance

Pavel Rotek wrote:
> Hello,
>
> i have problem with following table...
>
> create table dataaction (
>    id INT4 not null,
>    log text,
>    primary key (id)
> );
>
> It is the table for storing results of long running jobs. The log attribute
> takes approximately 5MB for one row (there is about 300 rows). My problem
> is, that table dataaction takes after restoring about 1,5G, but in few days
> grows to 79G(Toast space)...

1. What is happening with this table - just inserts, lots of updates?

2. What does SELECT sum(length(log)) FROM dataaction; show?

 > Vacuum on the table doesn't finish.

A plain vacuum doesn't finish, or vacuum full doesn't finish?

--
   Richard Huxton
   Archonet Ltd