Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits
| От | Tom Lane |
|---|---|
| Тема | Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits |
| Дата | |
| Msg-id | 959.1554436678@sss.pgh.pa.us обсуждение исходный текст |
| Ответ на | 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 (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 (Tom Lane, )
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 (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 (Tom Lane, )
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, )
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?
regards, tom lane
В списке pgsql-hackers по дате отправления: