Re: [GENERAL] Is it safe to INSERT/DELETE during VACUUM?

Поиск
Список
Период
Сортировка
От postgres@taifun.interface-business.de
Тема Re: [GENERAL] Is it safe to INSERT/DELETE during VACUUM?
Дата
Msg-id XFMail.991214102647.postgres@taifun.interface-business.de
обсуждение исходный текст
Ответ на Re: [GENERAL] Is it safe to INSERT/DELETE during VACUUM?  (Ed Loehr <ELOEHR@austin.rr.com>)
Список pgsql-general
Дерево обсуждения 
Hi Ed,

> Question:  is it safe to insert/update/delete during VACUUM?

We have done a stress test on FreeBSD 2.2.7 with PG 6.4.3 and
6.5.2 with 2 processes in parallel: the first runs VACUUM VERBOSE
in a loop and the second does INSERT/UPDATE/DELETE's.
The database crashed after <5 mins, with different errors (not
only "duplicate tuples").

Howto VACUUM an online database?

Gerald

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

Предыдущее
От: Elmar.Haneke@gmx.de
Дата:
Сообщение: Access rescrictions
Следующее
От: Mark Jewiss
Дата:
Сообщение: Re: [GENERAL] Clients in different Time Zones