X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4CC8340C04A for ; Sun, 30 Jan 2005 03:43:14 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 90998-01 for ; Sun, 30 Jan 2005 03:43:00 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id E496A40C061 for ; Sun, 30 Jan 2005 03:40:49 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j0U3ekGb078632 for ; Sun, 30 Jan 2005 03:40:46 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j0U1gnrR043952 for pgsql-admin@postgresql.org; Sun, 30 Jan 2005 01:42:49 GMT (envelope-from news) From: Ron Mayer X-Newsgroups: pgsql.admin Subject: Does anyone have a script to monitor if FSM settings are sufficient? Date: Sat, 29 Jan 2005 17:50:02 -0800 Organization: Hub.Org Networking Services Lines: 13 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200501/298 X-Sequence-Number: 16157 I may be implementing a database at a customer's site that would ideally run administration free for a year or so -- or at least be able to have scripts detect proactively if they'd need to call us for support before the system starts behaving poorly. Is there a way to parse the output of "vacuum" to tell me if my fsm settings aren't big enough to keep up, and or indicate a need to vacuum more frequently? Or am I better off looking at something else? Like perhaps log_min_duration_statement and tell them to call us if we see statements getting slow for any reason?