Re: Re: VACUUM and 24/7 database operation

Поиск
Список
Период
Сортировка
От Adam Lang
Тема Re: Re: VACUUM and 24/7 database operation
Дата
Msg-id 008801c08616$c95a1360$330a0a0a@6014cwpza006
обсуждение исходный текст
Ответ на VACUUM and 24/7 database operation  (Thomas.Favier@accelance.fr)
Список pgsql-general
Any type of commerce or site that tracks user profiles... That's a LOT of
sites that would have a need for a enterprise level DB.

Remember, the goal is 5 nines uptime. :)

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "Steve Wolfe" <steve@iboats.com>
To: <pgsql-general@postgresql.org>
Sent: Tuesday, January 23, 2001 3:52 PM
Subject: Re: [GENERAL] Re: VACUUM and 24/7 database operation


> > Shouldn't it be possible to build vacuum as an ongoing internal PG
> process,
> > instead of a seperate operation? How does Oracle byepass this? Must be
> some
> > way that can be implemented.
>
>   Well, here's what it comes down to:  Do you want updates to happen
> quickly, and vacuum when load is low, or do you want updates to be slow
all
> the time?  I suppose that there are some sites that can't find two minutes
> per day when updates will block (not selects), but I imagine they're very
> few.
>
> steve
>


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

Предыдущее
От: mwaples@waples.net
Дата:
Сообщение: postgresql user groups
Следующее
От: eschmid+sic@s.netic.de
Дата:
Сообщение: Re: Postgres-Book from addison-wesley?