Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits
От | Andres Freund |
---|---|
Тема | Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits |
Дата | |
Msg-id | 20190405054241.gsuwerewl6odhn7z@alap3.anarazel.de обсуждение исходный текст |
Ответ на | Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits (Darafei "Komяpa" Praliaskouski) |
Список | 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, )
Hi, On 2019-04-05 08:38:34 +0300, Darafei "Komяpa" Praliaskouski wrote: > On Fri, Apr 5, 2019 at 6:58 AM Tom Lane <> wrote: > > > Andres Freund <> writes: > > > I think the right approach would be to do all of this in heap_insert and > > > heap_multi_insert. Whenever starting to work on a page, if INSERT_FROZEN > > > is specified, remember whether it is either currently empty, or is > > > already marked as all-visible. If previously empty, mark it as all > > > visible at the end. If already all visible, there's no need to change > > > that. If not yet all-visible, no need to do anything, since it can't > > > have been inserted with COPY FREEZE. Do you see any problem doing it > > > that way? > > > > Do we want to add overhead to these hot-spot routines for this purpose? > > > > Sizing the overhead: workflows right now don't end with COPY FREEZE - you > need another VACUUM to set maps. > Anything that lets you skip that VACUUM (and faster than that VACUUM > itself) is helping. You specifically asked for it to be skippable with > FREEZE anyway. Tom's point was that the routines I was suggesting to adapt above aren't just used for COPY FREEZE. Greetings, Andres Freund
В списке pgsql-hackers по дате отправления: