Re: MaxOffsetNumber for Table AMs

Поиск
Список
Период
Сортировка
Искать
От
Peter Geoghegan
Тема
Re: MaxOffsetNumber for Table AMs
Дата
в 18:40:14
Msg-id
CAH2-Wz=2CvJ_z6vzY=W+HjX9QGGj8jKXQBKFpi6xMXReJutX6Q@mail.gmail.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 Wed, May 5, 2021 at 11:25 AM Andres Freund  wrote:
> Agreed. And we can increase the fit a good bit without needing invasive
> all-over changes. With those changes often even helping heap.
>
> E.g. tidbitmap.c's harcoded use of MaxHeapTuplesPerPage is a problem
> even for heap - we waste a lot of space that's not commonly used. A
> better datastructure (radix tree like I'd say, but several tree shaped
> approaches seem possible).

Agreed -- even if we only cared about heapam we still ought to do
something about tidbitmap.c's use of MaxHeapTuplesPerPage.

-- 
Peter Geoghegan


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