Re: fsutil ideas

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

In response to

Responses

Browse pgsql-hackers by date

  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