Re: Does anyone have a script to monitor if FSM settings are sufficient?

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?

-----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-----