Re: [HACKERS] Skip all-visible pages during second HeapScan of CIC
От | Andres Freund |
---|---|
Тема | Re: [HACKERS] Skip all-visible pages during second HeapScan of CIC |
Дата | |
Msg-id | 20170303225435.erbmcn6yn5b3itri@alap3.anarazel.de обсуждение исходный текст |
Ответ на | [HACKERS] Skip all-visible pages during second HeapScan of CIC (Pavan Deolasee <pavan.deolasee@gmail.com>) |
Ответы |
Re: [HACKERS] Skip all-visible pages during second HeapScan of CIC
Re: [HACKERS] Skip all-visible pages during second HeapScan of CIC |
Список | pgsql-hackers |
Hi, On 2017-02-28 19:12:03 +0530, Pavan Deolasee wrote: > Since VM bits are only set during VACUUM which conflicts with CIC on the > relation lock, I don't see any risk of incorrectly skipping pages that the > second scan should have scanned. I think that's true currently, but it'd also prevent us from doing that in additional places. Which, in my opinion, we really should (and I believe that's realistically achievable). Thus I really don't want to base the correctness of CIC - a relatively infrequent operation - on the assumption that no VM bits can be set concurrenty due to the SUE lock. Regards, Andres
В списке pgsql-hackers по дате отправления: