Re: CREATE INDEX and HOT - revised design

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: CREATE INDEX and HOT - revised design
Дата
Msg-id 19919.1175269764@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: CREATE INDEX and HOT - revised design  ("Pavan Deolasee" <pavan.deolasee@gmail.com>)
Ответы Re: CREATE INDEX and HOT - revised design
Re: CREATE INDEX and HOT - revised design
Список pgsql-hackers
"Pavan Deolasee" <pavan.deolasee@gmail.com> writes:
> How about storing the snapshot which we used during planning in
> CachedPlanSource, if at least one index was seen unusable because
> its CREATE INDEX transaction was seen as in-progress ?

I'm getting tired of repeating this, but: the planner doesn't use a
snapshot.  System catalogs run on SnapshotNow.
        regards, tom lane


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