Re: fsutil ideas - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: fsutil ideas
Date
Msg-id 43FED655.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Re: fsutil ideas  (Rod Taylor <pg@rbt.ca>)
Responses Re: fsutil ideas
List pgsql-hackers
>>> On Fri, Feb 24, 2006 at  9:34 am, in message
<1140795253.5092.122.camel@home>,
Rod Taylor <pg@rbt.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






pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: User privileges-verification required
Next
From: Peter Eisentraut
Date:
Subject: Remove ora2pg from contrib