X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id C60B49FA2FA for ; Wed, 10 May 2006 12:26:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 18502-02 for ; Wed, 10 May 2006 12:26:33 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from as2.cineca.com (as2.cineca.com [130.186.84.242]) by postgresql.org (Postfix) with ESMTP id 402009FA1B0 for ; Wed, 10 May 2006 12:26:31 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by as2.cineca.com (Postfix) with ESMTP id 5C8FD3AA21 for ; Wed, 10 May 2006 17:26:27 +0200 (CEST) Received: from cineca.mm.cineca.it (cineca.mm.cineca.it [130.186.10.200]) by as2.cineca.com (Postfix) with ESMTP id 8B16B3A9FB for ; Wed, 10 May 2006 17:26:16 +0200 (CEST) Received: from [130.186.7.26] (dhcp7-26.cineca.it [130.186.7.26]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) as user f.dallaca@cineca.it by cineca.mm.cineca.it (Postfix) with ESMTP id 416C7720C72 for ; Wed, 10 May 2006 17:26:16 +0200 (MEST) Message-ID: <44620618.9050903@cineca.it> From: Francesco Dalla Ca' Organization: CINECA User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.12) Gecko/20060202 Fedora/1.7.12-1.5.2 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Postgres monitoring Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Date: Wed, 10 May 2006 17:26:16 +0200 (MEST) X-Virus-Scanned: Cineca AppOs 0.85 at as2.cineca.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/107 X-Sequence-Number: 21639 Which parameters are critical for the activity of a server postgres? Which of these parameter (system parameter or postgres parameter) i must keep monitored to mantain postgres alive and fast? For example in mysql is important, no. of concurrent connection, no. of open files, table_cache, connect_time, error log, virtual memory (system), cpu (system) etc etc. Regards, Francesco. -- -------------------------------------------------- Francesco Dalla Ca' - Email: f.dallaca@cineca.it Settore Gestione Sistemi CINECA Via Magnanelli 6/3 40033 Casalecchio di Reno (BO) Bologna, Italy http://www.cineca.it --------------------------------------------------