pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Greg Smith <greg@2ndquadrant.com>
To: Merlin Moncure <mmoncure@gmail.com>
Cc: Grzegorz Jaśkiewicz <gryzman@gmail.com>
Cc: Krzysztof Kardas <krzychk2@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL with Zabbix - problem of newbe
Date: Fri, 09 Apr 2010 00:16:16 -0400
Message-ID: <4BBEAA10.6060808@2ndquadrant.com> (raw)
In-Reply-To: <p2ub42b73151004080616r994b020fp33350f9b982cf7b2@mail.gmail.com>
References: <v2w4ff8a7a31004080223mec26e053n69a2b80f24328f37@mail.gmail.com>
	<n2s2f4958ff1004080231m2cc8602au9eaf7f6d0ecc8bd@mail.gmail.com>
	<p2ub42b73151004080616r994b020fp33350f9b982cf7b2@mail.gmail.com>

Merlin Moncure wrote:
> postgresql 8.2: autovacuum enabled by default
> postgresql 8.3: HOT (reduces update penalty -- zabbix does a lot of updates)
>   

autovacuum wasn't enabled by default until 8.3.  It didn't really work 
all that well out of the box until the support for multiple workers was 
added in that version, along with some tweaking to its default 
parameters.  There's also a lot more logging information available, both 
the server logs and the statistics tables, to watch what it's doing that 
were added in 8.3.

-- 
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us




view thread (18+ messages)  latest in thread

Message-ID: <4BBEAA10.6060808@2ndquadrant.com>
Permalink:  ../4BBEAA10.6060808@2ndquadrant.com/
Also on:    postgresql.org/message-id/4BBEAA10.6060808@2ndquadrant.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: greg@2ndquadrant.com, mmoncure@gmail.com, gryzman@gmail.com, krzychk2@gmail.com
  Subject: Re: PostgreSQL with Zabbix - problem of newbe
  In-Reply-To: <4BBEAA10.6060808@2ndquadrant.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox