Toast space grows

From: "Pavel Rotek" <pavel(dot)rotek(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Toast space grows
Date: 2008-03-07 08:35:42
Message-ID: 3556c08c0803070035p6d8b4aa8m6318f54728f61022@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Oleg Bartunov 2008-03-07 08:44:18 Re: Improve Full text rank in a query
Previous Message Tom Lane 2008-03-07 06:35:46 Re: Nested loop vs merge join: inconsistencies between estimated and actual time