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  (Rod Taylor <pg@rbt.ca>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: User privileges-verification required
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Remove ora2pg from contrib