Trying to understand page structures in PG

Поиск
Список
Период
Сортировка
От Rakesh Kumar
Тема Trying to understand page structures in PG
Дата
Msg-id CAJBB=EXXbgzB_ae=0qHivA1FkTrRVZKSaoP1jvZLh687NXOmrA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Trying to understand page structures in PG  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Re: Trying to understand page structures in PG  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-general
Hello

I understand that when an update of say 100,000 rows are made, PG
writes the updated rows as a new row. These new rows are not visible
to any sessions except the one creating it. At commit time PG flips
something internally to make these rows visible to all.

My Q: what happens to those rows which use to contain the values
before the update. Shouldn't something change in those rows to
indicate that those rows are no longer valid. Who does it chain those
rows to the new rows.

thanks.


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

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: template1 being accessed
Следующее
От: Tobia Conforto
Дата:
Сообщение: Re: Exclude constraint using custom operator