Re: Toast space grows

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