On Tue, Oct 29, 2013 at 5:38 AM, Chris Travers <chris.travers@xxxxxxxxx> wrote: > > > > On Mon, Oct 28, 2013 at 4:17 PM, Gregory Haase <haaseg@xxxxxxxxxxxxxxxx> > wrote: >> >> I have a table that is triggering my nagios database bloat alert >> regularly. Usually, I have to give it the vacuum full more than once to get >> it under the threshold. Today I tried repeatedly and cannot get the alert to >> resolve. >> >> I had a discussion with one of the primary developers about how the table >> is utilized, and it turns out they are basically only ever inserting into >> it. This sort of flies in the face of conventional wisdom about bloat being >> caused by frequent updates and deletes. > > > As I understand it, vacuuming only removes the tuples removed by delete and > update operations. well, or by rolled back transactions. we we have to wonder if OP has a lot of queries trying to insert and failing. maybe check the log? merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
