Reindex and Vacuum togheter BUG ? [ was Vacuum bug ]

Поиск
Список
Период
Сортировка
От Gaetano Mendola
Тема Reindex and Vacuum togheter BUG ? [ was Vacuum bug ]
Дата
Msg-id b972er$mfs$1@news.hub.org
обсуждение исходный текст
Ответы Re: Reindex and Vacuum togheter BUG ? [ was Vacuum bug ]  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Some days ago I posted the fact that aftter a vacuum
I got a primary key duplicated, after investigation I realize that
may be was a  reindex on that table? I do almost 50 ( in a day )
vacuum analyze of entire DB e other 300 (in a day ) vacuum full of
particular tables.
Each morning at 07:10 AM I do a big db_purge with a reindex of
some tables ( the table with the duplicate key too ) and if this
operation take longs at 7:15 AM there are a reindex and a vacuum
analize that are running at the same time, may be this can be the
source of my problems ?

Regards
Gaetano

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

Предыдущее
От: Achilleus Mantzios
Дата:
Сообщение: Wrong index usage in 7.3.2
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Reindex and Vacuum togheter BUG ? [ was Vacuum bug ]