Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id E65C66334F2 for ; Fri, 9 Apr 2010 13:28:51 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 69417-07 for ; Fri, 9 Apr 2010 16:28:41 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-pv0-f174.google.com (mail-pv0-f174.google.com [74.125.83.174]) by mail.postgresql.org (Postfix) with ESMTP id 5A30A6332E0 for ; Fri, 9 Apr 2010 13:28:41 -0300 (ADT) Received: by pva18 with SMTP id 18so2099014pva.19 for ; Fri, 09 Apr 2010 09:28:40 -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 :content-transfer-encoding; bh=+lIe4VOGiamW20+W0Dchy76kElbf3rSXD7Ok35ZvXfQ=; b=EuGh1R4n9hbAGBLhyCxWyGbSAVgKsWIVwrs+iTJwfrKcGPZJe4b8/IBFh7D5GqUqXw 1/LWpqB0OVm2l3sCTgOoKLy8Pd6pxPOgg/I/MtHcUhlI9OpoKLrDgG3yiu3hX2EGJ9m3 HG9MQTpxX/maBPdYx1WUi5DdSsskWkUwaLQIE= 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:content-transfer-encoding; b=IY55CIEif6eLiPWKDZiI4TKsUsRZQx2Ily3epeqDqPhKO3Pw5WzErO/qnqd4WXy1MS /zcd78upHrMNx5Da7RK5VEWQWfptdb1iE5LnwNMpew0U8n0gDJn/eQedGmm/aPxk9hZN tNhUxEi1LB4tJu9YtQz2kZBzBaI24t6Y/rCNA= MIME-Version: 1.0 Received: by 10.142.90.8 with HTTP; Fri, 9 Apr 2010 09:28:40 -0700 (PDT) In-Reply-To: <4BBF4FDD.3090008@2ndquadrant.com> References: <4BBF4FDD.3090008@2ndquadrant.com> Date: Fri, 9 Apr 2010 10:28:40 -0600 Received: by 10.142.248.1 with SMTP id v1mr240627wfh.107.1270830520041; Fri, 09 Apr 2010 09:28:40 -0700 (PDT) Message-ID: Subject: Re: PostgreSQL with Zabbix - problem of newbe From: Scott Marlowe To: Greg Smith Cc: Krzysztof Kardas , pgsql-performance@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=-10 required=5 tests=FREEMAIL_FROM=0.001 X-Spam-Level: X-Archive-Number: 201004/119 X-Sequence-Number: 38369 On Fri, Apr 9, 2010 at 10:03 AM, Greg Smith wrote: > The main problem with this configuration is that work_mem is set to an > unsafe value--1.6GB. =A0With potentially 400 connections and about 2GB of= RAM > free after starting the server, work_mem=3D'4MB' is as large as you can s= afely > 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.