Re: set autovacuum=off

From: Thom Brown <thom(at)linux(dot)com>
To: Alessandro Gagliardi <alessandro(at)path(dot)com>
Cc: Andy Colson <andy(at)squeakycode(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: set autovacuum=off
Date: 2012-02-23 17:45:47
Message-ID: CAA-aLv6AHC=h5=y_OzGjfXRDH1a1sT5rx3uAQtv4s6v5_guiKQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 23 February 2012 17:35, Alessandro Gagliardi <alessandro(at)path(dot)com> wrote:
> I should have been more clear. I virtually never delete or do updates, but I
> insert a lot. So the table does change quite a bit, but only in one
> direction.

The same thing applies. VACUUM cleans up dead tuples, which INSERTs
don't create, only DELETE and UPDATEs do.

--
Thom

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Spiegelberg 2012-02-23 17:56:14 Re: Very long deletion time on a 200 GB database
Previous Message Alessandro Gagliardi 2012-02-23 17:35:07 Re: set autovacuum=off