Re: Investigating the reason for a very big TOAST table size - Mailing list pgsql-performance

From Daniel Farina
Subject Re: Investigating the reason for a very big TOAST table size
Date
Msg-id CAAZKuFYUTwhyO8Q2+CGFVVqVQdSn6xGzrWY-jG9E5eD4iHpMMA@mail.gmail.com
Whole thread Raw
In response to Re: Investigating the reason for a very big TOAST table size  (Daniel Farina <daniel@heroku.com>)
List pgsql-performance
On Tue, Aug 28, 2012 at 1:57 AM, Daniel Farina <daniel@heroku.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

pgsql-performance by date:

Previous
From: Daniel Farina
Date:
Subject: Re: Investigating the reason for a very big TOAST table size
Next
From: Merlin Moncure
Date:
Subject: Re: pg_trgm and slow bitmap index scan plan