Re: PostgreSQL with Zabbix - problem of newbe

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Greg Smith <greg(at)2ndquadrant(dot)com>
Cc: Krzysztof Kardas <krzychk2(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL with Zabbix - problem of newbe
Date: 2010-04-09 16:28:40
Message-ID: t2hdcc563d11004090928x25813de0vcf8cc859260eb8ab@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Apr 9, 2010 at 10:03 AM, Greg Smith <greg(at)2ndquadrant(dot)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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2010-04-09 16:30:26 Re: PostgreSQL with Zabbix - problem of newbe
Previous Message Jesper Krogh 2010-04-09 16:11:34 Re: 3ware vs. MegaRAID