Re: How to determine a database is intact?

Поиск
Список
Период
Сортировка
От Vivek Khera
Тема Re: How to determine a database is intact?
Дата
Msg-id x7hdq7fac5.fsf@yertle.int.kciLink.com
обсуждение исходный текст
Ответ на Re: How to determine a database is intact?  (Wes <wespvp@syntegra.com>)
Ответы Re: How to determine a database is intact?  (Jeff Amiel <jamiel@istreamimaging.com>)
Re: How to determine a database is intact?  (Wes <wespvp@syntegra.com>)
Список pgsql-general
>>>>> "W" == Wes  <wespvp@syntegra.com> writes:

W> I expect there are only a handful of huge databases running a heavy load -
W> the vast majority are probably tens no larger than 10's (maybe hundreds) of
W> megabytes, or do not experience a heavy update load?

Gigabytes: 40+ currently (old data is pruned)
Updates: jillions and jillions
Inserts: several hundred millions
Years: 3+
Corruptions: 0
Downtime: only for planned OS and Pg upgrades (7.1 -> 7.2 -> 7.4)
OS: FreeBSD 4.x
Hardware: Dell PowerEdge rackmount with SCSI hardware RAID

I sleep well at night :-)

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD  +1-301-869-4449 x806
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/

В списке pgsql-general по дате отправления:

Предыдущее
От: pw
Дата:
Сообщение: pg_attribute.attname
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: pg_attribute.attname