From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
---|---|
To: | "Rod Taylor" <pg(at)rbt(dot)ca> |
Cc: | <pgsql-hackers(at)postgresql(dot)org>,"Neil Conway" <neilc(at)samurai(dot)com>, "Peter Brant" <Peter(dot)Brant(at)wicourts(dot)gov> |
Subject: | Re: fsutil ideas |
Date: | 2006-02-24 15:48:06 |
Message-ID: | 43FED655.EE98.0025.0@wicourts.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>>> On Fri, Feb 24, 2006 at 9:34 am, in message
<1140795253(dot)5092(dot)122(dot)camel(at)home>,
Rod Taylor <pg(at)rbt(dot)ca> wrote:
>
> You don't need to know the free diskspace in real time. A 2 minute
old
> value is probably just as good.
Not really, this sort of monitoring has kept us from crashing under our
old database product when a poorly written query starts filling
available space by populating a temporary table. A green light turns
orange (indicating impending failure) on a big board which monitors the
health of about 200 servers and about 3000 workstations. A support
person drills down through the "LED" on a version of the "big board" in
their browser, which shows the supporting detail. A runaway query can
be identified and killed, protecting the rest of the users. A two
minute delay could cause an embarrassing interruption in service for
hundreds of our users.
Your suggestion would work for the gradual "outgrowing" of space, but
we need to cover both.
-Kevin
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2006-02-24 16:31:33 | Remove ora2pg from contrib |
Previous Message | Tom Lane | 2006-02-24 15:47:25 | Re: User privileges-verification required |