Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id B68D0633203 for ; Fri, 18 Jun 2010 15:12:11 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 34289-04 for ; Fri, 18 Jun 2010 18:12:04 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.9]) by mail.postgresql.org (Postfix) with ESMTP id 576D2632CEC for ; Fri, 18 Jun 2010 15:12:03 -0300 (ADT) Received: from [192.168.0.105] (pool-96-244-14-10.bltmmd.fios.verizon.net [96.244.14.10]) by mrelayeu.kundenserver.de (node=mrbap1) with ESMTP (Nemesis) id 0MIyAj-1ONDCU0s0n-002S0H; Fri, 18 Jun 2010 20:11:56 +0200 Message-ID: <4C1BB6E9.1090105@2ndquadrant.com> Date: Fri, 18 Jun 2010 14:11:53 -0400 From: Greg Smith User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: Kenneth Marshall CC: Tom Wilcox , Robert Haas , pgsql-performance@postgresql.org Subject: Re: requested shared memory size overflows size_t References: <584872.74177.qm@web39702.mail.mud.yahoo.com> <4C167A8D.1060002@gmail.com> <4C16B97F.4080201@gmail.com> <4C1A96A2.2050607@2ndquadrant.com> <4C1AB3C3.9090606@gmail.com> <20100618124826.GW23529@aart.is.rice.edu> In-Reply-To: <20100618124826.GW23529@aart.is.rice.edu> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V01U2FsdGVkX19P0d7mMg074IJyOfkJHfKrqc1HnxI0JnKgdrt zXLYfXYXD8G2Y9DHIZwBDpKaQ5iCFuz4d5cisZrHmeXRKQS7hs Yo5daXt80/ANynLY6hJnFE0W5H1v+ix X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-10 required=5 tests=BAYES_50=0.8, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201006/338 X-Sequence-Number: 39194 Kenneth Marshall wrote: > Zabbix-1.8+ is also worth taking a look at and it can run off our > favorite database. It allows for some very flexible monitoring and > trending data collection. > Note that while Zabbix is perfectly reasonable general solution, the number of things it monitors out of the box for PostgreSQL: http://www.zabbix.com/wiki/howto/monitor/db/postgresql is only a fraction of what Munin shows you. The main reason I've been suggesting Munin lately is because it seems to get all the basics right for new users without them having to do anything but activate the PostgreSQL plug-in. -- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support greg@2ndQuadrant.com www.2ndQuadrant.us