Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 7D13C2E0187 for ; Fri, 7 Mar 2008 04:35:46 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 91375-01 for ; Fri, 7 Mar 2008 04:35:40 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from hs-out-0708.google.com (hs-out-0708.google.com [64.233.178.241]) by postgresql.org (Postfix) with ESMTP id 98AE42E0113 for ; Fri, 7 Mar 2008 04:35:43 -0400 (AST) Received: by hs-out-0708.google.com with SMTP id x43so447111hsb.3 for ; Fri, 07 Mar 2008 00:35:42 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; bh=WjFSKfvBNXRn5hxP3fSZGMGBhXPvsqJBHK34nHnxEhw=; b=A2bef86rUNHfq7IF9iwm8L7ct4WOtptOl458mYM8TmSOxy5uBEsKcPVqHBrO38B+iyHb5Zycm0XF9PQZyIDAg06JaYO6k65PbzF7MuL2ISooaouwxzemABqjX37INE+H09MFY8cUBPyQ1B5pGRE4gKVaDfIt7kMrCVQoNEEW0W0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=Do/Kobkjh/8CJDmqoUb2vue/nwKxhBnVckAPbZqLm/nKTMVS6odrslVqLJA/g24hi9ydwzXSS3QYwasztIeMaWqYB6NATB4n9aSecPE7P0RLvRSzRFoPvKiBk3ZTD7yq6+uQDX9UZWm1KYkIJiWRLaDuWC3K1eXYo8Vk1X6DM6w= Received: by 10.64.153.4 with SMTP id a4mr203094qbe.15.1204878942074; Fri, 07 Mar 2008 00:35:42 -0800 (PST) Received: by 10.64.3.7 with HTTP; Fri, 7 Mar 2008 00:35:42 -0800 (PST) Message-ID: <3556c08c0803070035p6d8b4aa8m6318f54728f61022@mail.gmail.com> Date: Fri, 7 Mar 2008 09:35:42 +0100 From: "Pavel Rotek" To: pgsql-performance@postgresql.org Subject: Toast space grows MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_24993_32833014.1204878942051" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200803/149 X-Sequence-Number: 29103 ------=_Part_24993_32833014.1204878942051 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 ------=_Part_24993_32833014.1204878942051 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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
------=_Part_24993_32833014.1204878942051--