From: Scott Marlowe <scott.marlowe@gmail.com>
To: Greg Smith <greg@2ndquadrant.com>
Cc: Krzysztof Kardas <krzychk2@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL with Zabbix - problem of newbe
Date: Fri, 9 Apr 2010 10:28:40 -0600
Message-ID: <t2hdcc563d11004090928x25813de0vcf8cc859260eb8ab@mail.gmail.com> (raw)
In-Reply-To: <4BBF4FDD.3090008@2ndquadrant.com>
References: <v2w4ff8a7a31004080223mec26e053n69a2b80f24328f37@mail.gmail.com>
<4BBF4FDD.3090008@2ndquadrant.com>
On Fri, Apr 9, 2010 at 10:03 AM, Greg Smith <greg@2ndquadrant.com> wrote:
> The main problem with this configuration is that work_mem is set to an
> unsafe value--1.6GB. With potentially 400 connections and about 2GB of RAM
> free after starting the server, work_mem='4MB' is as large as you can safely
> set this.
> maintenance_work_mem | kB | 256MB
Note that 256MB maintenance_work_mem on a machine with 3 autovac
threads and only 2 Gig free is kinda high too.
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: scott.marlowe@gmail.com, greg@2ndquadrant.com, krzychk2@gmail.com
Subject: Re: PostgreSQL with Zabbix - problem of newbe
In-Reply-To: <t2hdcc563d11004090928x25813de0vcf8cc859260eb8ab@mail.gmail.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