Re: Unhappy about API changes in the no-fsm-for-small-rels patch

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: Unhappy about API changes in the no-fsm-for-small-rels patch
Дата
Msg-id
29729.1556040685@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
Unhappy about API changes in the no-fsm-for-small-rels patch Andres Freund <andres@anarazel.de>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Tom Lane <tgl@sss.pgh.pa.us>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Andres Freund <andres@anarazel.de>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Tom Lane <tgl@sss.pgh.pa.us>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch John Naylor <john.naylor@2ndquadrant.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Andres Freund <andres@anarazel.de>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Amit Kapila <amit.kapila16@gmail.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Andres Freund <andres@anarazel.de>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Tom Lane <tgl@sss.pgh.pa.us>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Andres Freund <andres@anarazel.de>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Andres Freund <andres@anarazel.de>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Bruce Momjian <bruce@momjian.us>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Andres Freund <andres@anarazel.de>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Bruce Momjian <bruce@momjian.us>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch John Naylor <john.naylor@2ndquadrant.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Amit Kapila <amit.kapila16@gmail.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Tom Lane <tgl@sss.pgh.pa.us>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Amit Kapila <amit.kapila16@gmail.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch John Naylor <john.naylor@2ndquadrant.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Amit Kapila <amit.kapila16@gmail.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Tom Lane <tgl@sss.pgh.pa.us>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Andres Freund <andres@anarazel.de>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch John Naylor <john.naylor@2ndquadrant.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Amit Kapila <amit.kapila16@gmail.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Amit Kapila <amit.kapila16@gmail.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Andres Freund <andres@anarazel.de>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Amit Kapila <amit.kapila16@gmail.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Andres Freund <andres@anarazel.de>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Tom Lane <tgl@sss.pgh.pa.us>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Andres Freund <andres@anarazel.de>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Amit Kapila <amit.kapila16@gmail.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Andres Freund <andres@anarazel.de>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Amit Kapila <amit.kapila16@gmail.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch John Naylor <john.naylor@2ndquadrant.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Amit Kapila <amit.kapila16@gmail.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch John Naylor <john.naylor@2ndquadrant.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Amit Kapila <amit.kapila16@gmail.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Amit Kapila <amit.kapila16@gmail.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch John Naylor <john.naylor@2ndquadrant.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Amit Kapila <amit.kapila16@gmail.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch John Naylor <john.naylor@2ndquadrant.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Amit Kapila <amit.kapila16@gmail.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch John Naylor <john.naylor@2ndquadrant.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Amit Kapila <amit.kapila16@gmail.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Amit Kapila <amit.kapila16@gmail.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Amit Kapila <amit.kapila16@gmail.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Andres Freund <andres@anarazel.de>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Tom Lane <tgl@sss.pgh.pa.us>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Amit Kapila <amit.kapila16@gmail.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Robert Haas <robertmhaas@gmail.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Andres Freund <andres@anarazel.de>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Robert Haas <robertmhaas@gmail.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Tom Lane <tgl@sss.pgh.pa.us>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Robert Haas <robertmhaas@gmail.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Andres Freund <andres@anarazel.de>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Robert Haas <robertmhaas@gmail.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Amit Kapila <amit.kapila16@gmail.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Tom Lane <tgl@sss.pgh.pa.us>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Andres Freund <andres@anarazel.de>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Tom Lane <tgl@sss.pgh.pa.us>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Andres Freund <andres@anarazel.de>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Tom Lane <tgl@sss.pgh.pa.us>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Andres Freund <andres@anarazel.de>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch John Naylor <john.naylor@2ndquadrant.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch John Naylor <john.naylor@2ndquadrant.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch John Naylor <john.naylor@2ndquadrant.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Amit Kapila <amit.kapila16@gmail.com>
Re: Unhappy about API changes in the no-fsm-for-small-rels patch John Naylor <john.naylor@2ndquadrant.com>
Andres Freund  writes:
> On 2019-04-23 15:46:17 +0530, Amit Kapila wrote:
>> If we invalidate it only when there's no space on the page, then when
>> should we set it back to available, because if we don't do that, then
>> we might miss the space due to concurrent deletes.

> Well, deletes don't traditionally (i.e. with an actual FSM) mark free
> space as available (for heap). I think RecordPageWithFreeSpace() should
> issue a invalidation if there's no FSM, and the block goes from full to
> empty (as there's no half-full IIUC).

Why wouldn't we implement this just as a mini four-entry FSM stored in
the relcache, and update the entries according to the same rules we'd
use for regular FSM entries?

			regards, tom lane


В списке pgsql-hackers по дате отправления
От: Fabien COELHO
Дата:
От: Shawn Debnath
Дата:
FAQ