pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Uwe C. Schroeder <uwe@oss4u.com>
To: Ron Mayer <rm_pg@cheapcomplexdevices.com>
To: pgsql-admin@postgresql.org
Subject: Re: Does anyone have a script to monitor if FSM settings are sufficient?
Date: Sat, 29 Jan 2005 22:53:46 -0800
Message-ID: <200501292253.46717.uwe@oss4u.com> (raw)
In-Reply-To: <cthe2p$1atf$1@news.hub.org>
References: <cthe2p$1atf$1@news.hub.org>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


What I'm doing in a case like that is have the system send a copy of the 
vacuum etc. messages to my email account. So I check in on those values once 
in a while and if I think I need to become active I actually call the 
customer and tell him it's time to do some maintenance.
Most customers appreciate the cost free service of monitoring the thing for 
them. Well, you'd certainly have to disclose up front that you'll be getting 
system information emails sent.

UC



On Saturday 29 January 2005 05:50 pm, Ron Mayer wrote:
> 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?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend

- --
Open Source Solutions 4U, LLC	2570 Fleetwood Drive
Phone:  +1 650 872 2425		San Bruno, CA 94066
Cell:   +1 650 302 2405		United States
Fax:    +1 650 872 2417
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQFB/IR6jqGXBvRToM4RAu7bAKCEICnKCy13ptyxHhjQlZePArVwpACgzGfX
rm5jWNtKkSnxF/FWGlZyrQU=
=Yj52
-----END PGP SIGNATURE-----




view thread (2+ messages)

Message-ID: <200501292253.46717.uwe@oss4u.com>
Permalink:  ../200501292253.46717.uwe@oss4u.com/
Also on:    postgresql.org/message-id/200501292253.46717.uwe@oss4u.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: uwe@oss4u.com, rm_pg@cheapcomplexdevices.com
  Subject: Re: Does anyone have a script to monitor if FSM settings are sufficient?
  In-Reply-To: <200501292253.46717.uwe@oss4u.com>
  References: <cthe2p$1atf$1@news.hub.org> <200501292253.46717.uwe@oss4u.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox