Re: fsutil ideas
От | Kevin Grittner |
---|---|
Тема | Re: fsutil ideas |
Дата | |
Msg-id | 43FED655.EE98.0025.0@wicourts.gov обсуждение исходный текст |
Ответ на | Re: fsutil ideas (Rod Taylor <pg@rbt.ca>) |
Ответы |
Re: fsutil ideas
|
Список | 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 по дате отправления: