From: Richard Huxton <dev@archonet.com>
To: Pavel Rotek <pavel.rotek@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Toast space grows
Date: Fri, 07 Mar 2008 09:13:06 +0000
Message-ID: <47D10722.4080508@archonet.com> (raw)
In-Reply-To: <3556c08c0803070035p6d8b4aa8m6318f54728f61022@mail.gmail.com>
References: <3556c08c0803070035p6d8b4aa8m6318f54728f61022@mail.gmail.com>
Pavel Rotek wrote:
> 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)...
1. What is happening with this table - just inserts, lots of updates?
2. What does SELECT sum(length(log)) FROM dataaction; show?
> Vacuum on the table doesn't finish.
A plain vacuum doesn't finish, or vacuum full doesn't finish?
--
Richard Huxton
Archonet Ltd
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: dev@archonet.com, pavel.rotek@gmail.com
Subject: Re: Toast space grows
In-Reply-To: <47D10722.4080508@archonet.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