Re: ANALYZE locks pg_listener in EXCLUSIVE for long time?

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB SD
Тема Re: ANALYZE locks pg_listener in EXCLUSIVE for long time?
Дата
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA40184D0B2@m0114.s-mxs.net
обсуждение исходный текст
Ответ на ANALYZE locks pg_listener in EXCLUSIVE for long time?  (Philip Warner <pjw@rhyme.com.au>)
Ответы Re: ANALYZE locks pg_listener in EXCLUSIVE for long time?
Список pgsql-hackers
> * Is it really a good idea for database-wide ANALYZE to run as a single
> transaction?  Holding all those locks is a recipe for deadlocks, even
> if they're as inoffensive as AccessShareLocks normally are.

Wasn't one idea behind that change also to not make the planner create a plan
from mixed old and new statistics ? I guess that could later be accomplished with
"begin work; analyze; commit work;" (with subtransactions) though.

Andreas


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

Предыдущее
От: Andrew Hammond
Дата:
Сообщение: Re: Is there any method to keep table in memory at startup
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ANALYZE locks pg_listener in EXCLUSIVE for long time?