Toast space grows

Поиск
Список
Период
Сортировка
От Pavel Rotek
Тема Toast space grows
Дата
Msg-id 3556c08c0803070035p6d8b4aa8m6318f54728f61022@mail.gmail.com
обсуждение исходный текст
Ответы Re: Toast space grows  (Richard Huxton <dev@archonet.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Nested loop vs merge join: inconsistencies between estimated and actual time
Следующее
От: Oleg Bartunov
Дата:
Сообщение: Re: Improve Full text rank in a query