From: Pavel Rotek <pavel.rotek@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Toast space grows
Date: Fri, 7 Mar 2008 09:35:42 +0100
Message-ID: <3556c08c0803070035p6d8b4aa8m6318f54728f61022@mail.gmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pavel.rotek@gmail.com
Subject: Re: Toast space grows
In-Reply-To: <3556c08c0803070035p6d8b4aa8m6318f54728f61022@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox