Toast space grows - Mailing list pgsql-performance

From Pavel Rotek
Subject Toast space grows
Date
Msg-id 3556c08c0803070035p6d8b4aa8m6318f54728f61022@mail.gmail.com
Whole thread Raw
Responses Re: Toast space grows  (Richard Huxton <dev@archonet.com>)
List pgsql-performance
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)... Vacuum on the table doesn't finish.

Where can be the problem?? How to solve it, how to shrink toast space??

Any help will be appretiated.

Kind regards,

Pavel Rotek

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Nested loop vs merge join: inconsistencies between estimated and actual time
Next
From: Oleg Bartunov
Date:
Subject: Re: Improve Full text rank in a query