Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 8765F632224
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu,  8 Apr 2010 06:32:24 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 58119-02
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu,  8 Apr 2010 09:32:07 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-bw0-f216.google.com (mail-bw0-f216.google.com
	[209.85.218.216])
	by mail.postgresql.org (Postfix) with ESMTP id 91F3263279A
	for <pgsql-performance@postgresql.org>;
	Thu,  8 Apr 2010 06:31:36 -0300 (ADT)
Received: by bwz8 with SMTP id 8so74239bwz.3
	for <pgsql-performance@postgresql.org>;
	Thu, 08 Apr 2010 02:31:35 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:received:message-id:subject:from:to:cc:content-type;
	bh=xhSNf9jZ9K9/qnnQOmNQQdO739GQeKfiPMv18jOeSOs=;
	b=GDh0+cmelSh+NU5eYmfF5esxg/Vu8AN6JQ/NUpoYjiUhU7clM+1CPikYPqKTOLOvME
	yFzcdcObow5P0rp1D/iICdwSvq7unHRrBjJ24SOF75NlLuQR5iZXScC3/4OK0cc3NFH7
	8NF6OITmf0qdmEgYEujqZQMloex2HsLeuWBQc=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=e8qmKrgwTN+RSsF7TJ9eazzF+LUooAk87J+bn3ZNT7AmHND5GnAP5Dptaf3loyajMH
	Y/iF0/SkF9UjRGjqmJl702dGwaNeBmRPiLQWwiESMuC+5vp8Hy5il8OnTTgYfgEPue3e
	cNUWXv21Kmp2AXBsFZxsJch9oTO+uHG1TeW0Q=
MIME-Version: 1.0
Received: by 10.204.46.154 with HTTP; Thu, 8 Apr 2010 02:31:34 -0700 (PDT)
In-Reply-To: <v2w4ff8a7a31004080223mec26e053n69a2b80f24328f37@mail.gmail.com>
References: <v2w4ff8a7a31004080223mec26e053n69a2b80f24328f37@mail.gmail.com>
Date: Thu, 8 Apr 2010 10:31:34 +0100
Received: by 10.204.83.132 with SMTP id f4mr1306944bkl.73.1270719094977; Thu,
	08 Apr 2010 02:31:34 -0700 (PDT)
Message-ID: <n2s2f4958ff1004080231m2cc8602au9eaf7f6d0ecc8bd@mail.gmail.com>
Subject: Re: PostgreSQL with Zabbix - problem of newbe
From: =?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= <gryzman@gmail.com>
To: Krzysztof Kardas <krzychk2@gmail.com>
Cc: pgsql-performance@postgresql.org
Content-Type: multipart/alternative; boundary=0016e6d77df843f5610483b658d8
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.178 tagged_above=-10 required=5 tests=AWL=-0.439,
	BAYES_20=-0.74, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201004/93
X-Sequence-Number: 38343

--0016e6d77df843f5610483b658d8
Content-Type: text/plain; charset=UTF-8

starting with 8.3, there's this new feature called HOT, which helps a lot
when you do loads of updates.
Plus writer is much quicker (30-40% sometimes), and autovacuum behaves much
nicer.
Bottom line, upgrade to 8.3, 8.1 had autovacuum disabled by default for a
reason.

--0016e6d77df843f5610483b658d8
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

starting with 8.3, there&#39;s this new feature called HOT, which helps a l=
ot when you do loads of updates. <br>Plus writer is much quicker (30-40% so=
metimes), and autovacuum behaves much nicer. <br>Bottom line, upgrade to 8.=
3, 8.1 had autovacuum disabled by default for a reason.<br>
<br>

--0016e6d77df843f5610483b658d8--