Re: Investigating the reason for a very big TOAST table size

From: Daniel Farina <daniel(at)heroku(dot)com>
To: Liron Shiri <lirons(at)checkpoint(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Investigating the reason for a very big TOAST table size
Date: 2012-08-28 08:59:15
Message-ID: CAAZKuFYUTwhyO8Q2+CGFVVqVQdSn6xGzrWY-jG9E5eD4iHpMMA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Aug 28, 2012 at 1:57 AM, Daniel Farina <daniel(at)heroku(dot)com> wrote:
> My database has taken many days (over a week) to stabilize. I was
> about to write that it never stops growing (we'd eventually have to
> VACUUM FULL or do a column rotation), but that is not true. This
> graph is a bit spotty for unrelated reasons, but here's something like
> what I'm seeing:
>
> http://i.imgur.com/tbj1n.png

Graph in attachment form for posterity of the archives. I forgot they
take attachments.

--
fdr

Attachment Content-Type Size
image/png 24.8 KB

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2012-08-28 13:27:24 Re: pg_trgm and slow bitmap index scan plan
Previous Message Daniel Farina 2012-08-28 08:57:58 Re: Investigating the reason for a very big TOAST table size