Re: set autovacuum=off

To: Alessandro Gagliardi <alessandro@xxxxxxxx>
Subject: Re: set autovacuum=off
From: Filippos Kalamidas <filippos.kal@xxxxxxxxx>
Date: Mon, 27 Feb 2012 23:59:56 +0200
Authentication-results: mr.google.com; spf=pass (google.com: domain of filippos.kal@xxxxxxxxx designates 10.112.105.164 as permitted sender) smtp.mail=filippos.kal@xxxxxxxxx; dkim=pass header.i=filippos.kal@xxxxxxxxx
Cc: Peter van Hardenberg <pvh@xxxxxxxxxx>, Andy Colson <andy@xxxxxxxxxxxxxxx>, pgsql-performance@xxxxxxxxxxxxxx
In-reply-to: <CANUP4k13Lqc5HfsEMGaZKsycNxwJ4A5YW4OBC2tLycjY=DwXGQ@mail.gmail.com>
References: <CAAB3BBLsZ94tTzaiTZrdpK+2m1waj8=VL31aPvOGFJ7oAGCHiQ@mail.gmail.com> <CAA-aLv4KL4atuaqJFi3BBWiRsWiJOVQZMk65JYw=H8ezZV6O8g@mail.gmail.com> <4F4658CB.3030505@squeakycode.net> <CAAB3BBK-nzheaG4Ju0snB7b3hqc2pZ+wV6vv9BPt81_k_cLcWw@mail.gmail.com> <4F467EDF.5090708@pinpointresearch.com> <CAAB3BBKU4f3QqNMmjYeuZFkOhp6iP+2aMhLWODQBEMQt-+yCnA@mail.gmail.com> <4F4692FF.3080703@pinpointresearch.com> <CAAB3BBJ9_4g3pk_M9DRcO_zS8_DHx0eZDSRgAZmXJ4qz9e5fXw@mail.gmail.com> <CAFqOt8Hw3kzDfPdjWi9Xh2qRWBh7jBiT7yG6di4dMjeONQ0E2Q@mail.gmail.com> <CAAB3BBJJE0MYZ=ftCZJyoLDSd6vCrL4yNHNFs9KrMLm_9v=7CA@mail.gmail.com> <CANUP4k13Lqc5HfsEMGaZKsycNxwJ4A5YW4OBC2tLycjY=DwXGQ@mail.gmail.com>

you might also consider increasing the wal_buffers value if it's still the default (64KB)

BR

References:
- set autovacuum=off
  - From: Alessandro Gagliardi
- Re: set autovacuum=off
  - From: Thom Brown
- Re: set autovacuum=off
  - From: Andy Colson
- Re: set autovacuum=off
  - From: Alessandro Gagliardi
- Re: set autovacuum=off
  - From: Steve Crawford
- Re: set autovacuum=off
  - From: Alessandro Gagliardi
- Re: set autovacuum=off
  - From: Steve Crawford
- Re: set autovacuum=off
  - From: Alessandro Gagliardi
- Re: set autovacuum=off
  - From: Peter van Hardenberg
- Re: set autovacuum=off
  - From: Alessandro Gagliardi
- Re: set autovacuum=off
  - From: Filippos Kalamidas