Re: set autovacuum=off

[Alessandro Gagliardi <alessandro@xxxxxxxx>]

Hm. Okay, so just to be perfectly clear, my database with all its INSERTs, but no DELETEs or UPDATEs should not be VACUUMing anyway, so disabling auto-vacuum is redundant (and possibly hazardous).

FWIW, I did notice a speed increase after disabling auto-vacuum on several of my tables though that could have been a coincidence. Is there any way that these tables could have been getting vacuumed (or some thing else) despite the fact that they are not receiving updates or deletes? Or must that have been a coincidence?

While we're on the subject, I welcome any pointers with regard to tuning a database that is being used in this way. Any cache sizes I should be messing with? Etc.

Thank you,

-Alessandro

On Thu, Feb 23, 2012 at 9:45 AM, Thom Brown <thom@xxxxxxxxx> wrote:

On 23 February 2012 17:35, Alessandro Gagliardi <alessandro@xxxxxxxx> 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