Re: Analyze during a transaction

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Analyze during a transaction
Дата
Msg-id 52618284.6090909@gmx.net
обсуждение исходный текст
Ответ на Analyze during a transaction  (bobJobS <russelljanusz@yahoo.com>)
Список pgsql-general
Дерево обсуждения 
On 10/18/13 12:28 PM, bobJobS wrote:
> If I analyze our database during a transaction and the transaction fails
> (rollback occurs), with the table statistics rollback to their original
> values?

Yes.

ANALYZE isn't really that special.  It reads data from some tables, does
some math on it, and writes the results to other tables (pg_statistic).
 All of that is subject to transaction semantics.

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

Предыдущее
От: Rémi Cura
Дата:
Сообщение: Re: Cannot import logs from csv
Следующее
От: Adam Jelinek
Дата:
Сообщение: Re: Bug? Function with side effects not evaluated in CTE