From: Greg Smith <greg@2ndquadrant.com>
To: Krzysztof Kardas <krzychk2@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL with Zabbix - problem of newbe
Date: Thu, 08 Apr 2010 22:31:40 -0400
Message-ID: <4BBE918C.7040105@2ndquadrant.com> (raw)
In-Reply-To: <v2w4ff8a7a31004080223mec26e053n69a2b80f24328f37@mail.gmail.com>
References: <v2w4ff8a7a31004080223mec26e053n69a2b80f24328f37@mail.gmail.com>
Krzysztof Kardas wrote:
> My current database variables:
>
That is way too much stuff to sort through. Try this instead, to only
get the values you've set to something rather than every single one:
select name,unit,current_setting(name) from pg_settings where
source='configuration file' ;
Also, a snapshot of output from "vmstat 1" during some period when the
server is performing badly would be very helpful to narrow down what's
going on.
The easy answer to your question is simply that autovacuum is terrible
on PG 8.1. You can tweak it to do better, but that topic isn't covered
very well in the sort of tuning guides you'll find floating around.
This is because most of the people who care about this sort of issue
have simply upgraded to a later version where autovacuum is much better.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.us
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, krzychk2@gmail.com
Subject: Re: PostgreSQL with Zabbix - problem of newbe
In-Reply-To: <4BBE918C.7040105@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