Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group