Re: Statistics Import and Export

Поиск
Список
Период
Сортировка
От Corey Huinker
Тема Re: Statistics Import and Export
Дата
Msg-id CADkLM=daBsKfo3CO1gP0HQ17wFzDKW+gha=2z_fSaa9Fs5csTA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Statistics Import and Export  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: Statistics Import and Export  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-hackers
No, we should be keeping the lock until the end of the transaction
(which in this case would be just the one statement, but it would be the
whole statement and all of the calls in it).  See analyze.c:268 or
so, where we call relation_close(onerel, NoLock); meaning we're closing
the relation but we're *not* releasing the lock on it- it'll get
released at the end of the transaction.


If that's the case, then changing the two table_close() statements to NoLock should resolve any remaining concern.
 

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

Предыдущее
От: Teodor Sigaev
Дата:
Сообщение: Re: type cache cleanup improvements
Следующее
От: Bharath Rupireddy
Дата:
Сообщение: Re: Introduce XID age and inactive timeout based replication slot invalidation