Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits
От | Tatsuo Ishii |
---|---|
Тема | Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits |
Дата | |
Msg-id | 20201028.144653.966121790856478893.t-ishii@sraoss.co.jp обсуждение исходный текст |
Ответ на | Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Anastasia Lubennikova) |
Ответы |
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits
(Tomas Vondra)
|
Список | pgsql-hackers |
Дерево обсуждения
COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits
(Pavan Deolasee,
)
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Kuntal Ghosh, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Simon Riggs, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Kuntal Ghosh, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Jeff Janes, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Pavan Deolasee, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Masahiko Sawada, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Pavan Deolasee, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Masahiko Sawada, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Pavan Deolasee, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Masahiko Sawada, )
Re: Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (David Steele, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Pavan Deolasee, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Darafei Praliaskouski, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Masahiko Sawada, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Pavan Deolasee, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Pavan Deolasee, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Tomas Vondra, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Andres Freund, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Alvaro Herrera, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Andres Freund, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Andres Freund, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Alvaro Herrera, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Andres Freund, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Pavan Deolasee, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Andres Freund, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Pavan Deolasee, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Andres Freund, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Tom Lane, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Andres Freund, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Andres Freund, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Andres Freund, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Pavan Deolasee, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Pavan Deolasee, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Amit Kapila, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Ibrar Ahmed, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Darafei "Komяpa" Praliaskouski, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Andres Freund, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Ibrar Ahmed, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Ibrar Ahmed, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Daniel Gustafsson, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Anastasia Lubennikova, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Robert Haas, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Anastasia Lubennikova, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Ibrar Ahmed, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Hamid Akhtar, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Ibrar Ahmed, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Alvaro Herrera, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Anastasia Lubennikova, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Ibrar Ahmed, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Anastasia Lubennikova, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Ibrar Ahmed, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Anastasia Lubennikova, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Tatsuo Ishii, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Tomas Vondra, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Anastasia Lubennikova, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Tomas Vondra, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Anastasia Lubennikova, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Tomas Vondra, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Anastasia Lubennikova, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Tomas Vondra, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Anastasia Lubennikova, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Tomas Vondra, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Tomas Vondra, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Tatsuo Ishii, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Pavan Deolasee, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Kuntal Ghosh, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Simon Riggs, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Kuntal Ghosh, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Jeff Janes, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Pavan Deolasee, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Masahiko Sawada, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Pavan Deolasee, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Masahiko Sawada, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Pavan Deolasee, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Masahiko Sawada, )
Re: Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (David Steele, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Pavan Deolasee, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Darafei Praliaskouski, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Masahiko Sawada, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Pavan Deolasee, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Pavan Deolasee, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Tomas Vondra, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Andres Freund, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Alvaro Herrera, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Andres Freund, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Andres Freund, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Alvaro Herrera, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Andres Freund, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Pavan Deolasee, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Andres Freund, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Pavan Deolasee, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Andres Freund, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Tom Lane, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Andres Freund, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Andres Freund, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Andres Freund, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Pavan Deolasee, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Pavan Deolasee, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Amit Kapila, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Ibrar Ahmed, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Darafei "Komяpa" Praliaskouski, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Andres Freund, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Ibrar Ahmed, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Ibrar Ahmed, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Daniel Gustafsson, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Anastasia Lubennikova, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Robert Haas, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Anastasia Lubennikova, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Ibrar Ahmed, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Hamid Akhtar, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Ibrar Ahmed, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Alvaro Herrera, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Anastasia Lubennikova, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Ibrar Ahmed, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Anastasia Lubennikova, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Ibrar Ahmed, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Anastasia Lubennikova, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Tatsuo Ishii, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Tomas Vondra, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Anastasia Lubennikova, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Tomas Vondra, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Anastasia Lubennikova, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Tomas Vondra, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Anastasia Lubennikova, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Tomas Vondra, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Anastasia Lubennikova, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Tomas Vondra, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Tomas Vondra, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Tatsuo Ishii, )
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Pavan Deolasee, )
> Status update for a commitfest entry. > > This patch is ReadyForCommitter. It applies and passes the CI. There are no unanswered questions in the discussion. > > The discussion started in 2015 with a patch by Jeff Janes. Later it was revived by Pavan Deolasee. After it was pickedup by Ibrar Ahmed and finally, it was rewritten by me, so I moved myself from reviewers to authors as well. > > The latest version was reviewed and tested by Ibrar Ahmed. The patch doesn't affect COPY FREEZE performance and significantlydecreases the time of the following VACUUM. I have tested the patch on my laptop (mem 16GB, SSD 512GB) using the data introduced in up thread and saw that VACCUM after COPY FREEZE is nearly 60 times faster than current master branch. Quite impressive. By the way, I noticed following comment: + /* + * vmbuffer should be already pinned by RelationGetBufferForTuple, + * Though, it's fine if is not. all_frozen is just an optimization. + */ could be enhanced like below. What do you think? + /* + * vmbuffer should be already pinned by RelationGetBufferForTuple. + * Though, it's fine if it is not. all_frozen is just an optimization. + */ Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:http://www.sraoss.co.jp
В списке pgsql-hackers по дате отправления:
Следующее
От: Bharath RupireddyДата:
Сообщение: Re: A new function to wait for the backend exit after termination