Re: MaxOffsetNumber for Table AMs

Поиск
Список
Период
Сортировка
Искать
От
Jeff Davis
Тема
Re: MaxOffsetNumber for Table AMs
Дата
Msg-id
50948761ea906849915e299950a1b42ca30c7d6d.camel@j-davis.com
Ответ на
Список
Дерево обсуждения
MaxOffsetNumber for Table AMs Jeff Davis <pgsql@j-davis.com>
Re: MaxOffsetNumber for Table AMs Tom Lane <tgl@sss.pgh.pa.us>
Re: MaxOffsetNumber for Table AMs Jeff Davis <pgsql@j-davis.com>
Re: MaxOffsetNumber for Table AMs Tom Lane <tgl@sss.pgh.pa.us>
Re: MaxOffsetNumber for Table AMs Jeff Davis <pgsql@j-davis.com>
Re: MaxOffsetNumber for Table AMs Jeff Davis <pgsql@j-davis.com>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Jeff Davis <pgsql@j-davis.com>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Jeff Davis <pgsql@j-davis.com>
Re: MaxOffsetNumber for Table AMs Jeff Davis <pgsql@j-davis.com>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Jeff Davis <pgsql@j-davis.com>
Re: MaxOffsetNumber for Table AMs Robert Haas <robertmhaas@gmail.com>
Re: MaxOffsetNumber for Table AMs Tom Lane <tgl@sss.pgh.pa.us>
Re: MaxOffsetNumber for Table AMs Robert Haas <robertmhaas@gmail.com>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Robert Haas <robertmhaas@gmail.com>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Robert Haas <robertmhaas@gmail.com>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Andres Freund <andres@anarazel.de>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Andres Freund <andres@anarazel.de>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Robert Haas <robertmhaas@gmail.com>
Re: MaxOffsetNumber for Table AMs Jeff Davis <pgsql@j-davis.com>
Re: MaxOffsetNumber for Table AMs Robert Haas <robertmhaas@gmail.com>
Re: MaxOffsetNumber for Table AMs Andres Freund <andres@anarazel.de>
Re: MaxOffsetNumber for Table AMs Jeff Davis <pgsql@j-davis.com>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Jeff Davis <pgsql@j-davis.com>
Re: MaxOffsetNumber for Table AMs Andres Freund <andres@anarazel.de>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Hannu Krosing <hannuk@google.com>
Re: MaxOffsetNumber for Table AMs Jeff Davis <pgsql@j-davis.com>
Re: MaxOffsetNumber for Table AMs Robert Haas <robertmhaas@gmail.com>
Re: MaxOffsetNumber for Table AMs Hannu Krosing <hannuk@google.com>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Jeff Davis <pgsql@j-davis.com>
Re: MaxOffsetNumber for Table AMs Robert Haas <robertmhaas@gmail.com>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Robert Haas <robertmhaas@gmail.com>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Matthias van de Meent <boekewurm+postgres@gmail.com>
Re: MaxOffsetNumber for Table AMs Robert Haas <robertmhaas@gmail.com>
Re: MaxOffsetNumber for Table AMs Hannu Krosing <hannuk@google.com>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Matthias van de Meent <boekewurm+postgres@gmail.com>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Matthias van de Meent <boekewurm+postgres@gmail.com>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Jeff Davis <pgsql@j-davis.com>
Re: MaxOffsetNumber for Table AMs Robert Haas <robertmhaas@gmail.com>
Re: MaxOffsetNumber for Table AMs Jeff Davis <pgsql@j-davis.com>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Robert Haas <robertmhaas@gmail.com>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Robert Haas <robertmhaas@gmail.com>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Robert Haas <robertmhaas@gmail.com>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Jeff Davis <pgsql@j-davis.com>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Robert Haas <robertmhaas@gmail.com>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Robert Haas <robertmhaas@gmail.com>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Jeff Davis <pgsql@j-davis.com>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Matthias van de Meent <boekewurm+postgres@gmail.com>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Robert Haas <robertmhaas@gmail.com>
Re: MaxOffsetNumber for Table AMs Jeff Davis <pgsql@j-davis.com>
Re: MaxOffsetNumber for Table AMs Robert Haas <robertmhaas@gmail.com>
Re: MaxOffsetNumber for Table AMs Jeff Davis <pgsql@j-davis.com>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Jeff Davis <pgsql@j-davis.com>
Re: MaxOffsetNumber for Table AMs Matthias van de Meent <boekewurm+postgres@gmail.com>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Jeff Davis <pgsql@j-davis.com>
Re: MaxOffsetNumber for Table AMs Peter Geoghegan <pg@bowt.ie>
Re: MaxOffsetNumber for Table AMs Jeff Davis <pgsql@j-davis.com>
Re: MaxOffsetNumber for Table AMs Matthias van de Meent <boekewurm+postgres@gmail.com>
Re: MaxOffsetNumber for Table AMs Jeff Davis <pgsql@j-davis.com>
On Fri, 2021-04-30 at 11:06 -0400, Tom Lane wrote:
> My thought at the moment is that all APIs above the AM level ought
> to be redefined to use uint64 for tuple identifiers.

One challenge might be reliance on InvalidOffsetNumber as a special
value in a number of places (e.g. bitmap index scans). That doesn't
seem like a major problem though.

> heapam and
> related index AMs could map block + offset into that in some
> convenient way, and other AMs could do what they like.

Do you mean that indexes would be expected to hold a uint64, a 48-bit
int (that directly maps to a uint64), or still hold an ItemPointerData?

Regards,
	Jeff Davis




В списке pgsql-hackers по дате отправления
От: Andres Freund
Дата:
От: Tom Lane
Дата:
FAQ