Re: BitmapHeapScan streaming read user and prelim refactoring

Поиск
Список
Период
Сортировка
Искать
От
Melanie Plageman
Тема
Re: BitmapHeapScan streaming read user and prelim refactoring
Дата
Msg-id
20240323002607.abegehmmjyxrnmm2@liskov
Ответ на
Список
Дерево обсуждения
BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Andres Freund <andres@anarazel.de>
Re: BitmapHeapScan streaming read user and prelim refactoring Heikki Linnakangas <hlinnaka@iki.fi>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Heikki Linnakangas <hlinnaka@iki.fi>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Thomas Munro <thomas.munro@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tom Lane <tgl@sss.pgh.pa.us>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Michael Paquier <michael@paquier.xyz>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Michael Paquier <michael@paquier.xyz>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: BitmapHeapScan streaming read user and prelim refactoring Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: BitmapHeapScan streaming read user and prelim refactoring Robert Haas <robertmhaas@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tom Lane <tgl@sss.pgh.pa.us>
Re: BitmapHeapScan streaming read user and prelim refactoring Tom Lane <tgl@sss.pgh.pa.us>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Daniel Gustafsson <daniel@yesql.se>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Richard Guo <guofenglinux@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Robert Haas <robertmhaas@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tom Lane <tgl@sss.pgh.pa.us>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Heikki Linnakangas <hlinnaka@iki.fi>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Thomas Munro <thomas.munro@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Thomas Munro <thomas.munro@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Thomas Munro <thomas.munro@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Thomas Munro <thomas.munro@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Heikki Linnakangas <hlinnaka@iki.fi>
Re: BitmapHeapScan streaming read user and prelim refactoring Dilip Kumar <dilipbalaut@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Robert Haas <robertmhaas@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Dilip Kumar <dilipbalaut@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Heikki Linnakangas <hlinnaka@iki.fi>
Re: BitmapHeapScan streaming read user and prelim refactoring Robert Haas <robertmhaas@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Heikki Linnakangas <hlinnaka@iki.fi>
Re: BitmapHeapScan streaming read user and prelim refactoring Robert Haas <robertmhaas@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Dilip Kumar <dilipbalaut@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Heikki Linnakangas <hlinnaka@iki.fi>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Andres Freund <andres@anarazel.de>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Andres Freund <andres@anarazel.de>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Andres Freund <andres@anarazel.de>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Mark Dilger <mark.dilger@enterprisedb.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman <melanieplageman@gmail.com>
Re: BitmapHeapScan streaming read user and prelim refactoring Mark Dilger <mark.dilger@enterprisedb.com>
On Fri, Mar 22, 2024 at 08:22:11PM -0400, Melanie Plageman wrote:
> On Tue, Mar 19, 2024 at 02:33:35PM +0200, Heikki Linnakangas wrote:
> > On 18/03/2024 17:19, Melanie Plageman wrote:
> > > I've attached v7 rebased over this commit.
> > 
> > If we delayed table_beginscan_bm() call further, after starting the TBM
> > iterator, we could skip it altogether when the iterator is empty.
> > 
> > That's a further improvement, doesn't need to be part of this patch set.
> > Just caught my eye while reading this.
> 
> Hmm. You mean like until after the first call to tbm_[shared]_iterate()?
> AFAICT, tbm_begin_iterate() doesn't tell us anything about whether or
> not the iterator is "empty". Do you mean cases when the bitmap has no
> blocks in it? It seems like we should be able to tell that from the
> TIDBitmap.
> 
> > 
> > > v7-0003-Push-BitmapHeapScan-skip-fetch-optimization-into-.patch
> > 
> > I suggest to avoid the double negative with SO_CAN_SKIP_FETCH, and call the
> > flag e.g. SO_NEED_TUPLE.
> 
> Agreed. Done in attached v8. Though I wondered if it was a bit weird
> that the flag is set in the common case and not set in the uncommon
> case...

v8 actually attached this time
В списке pgsql-hackers по дате отправления
От: Thomas Munro
Дата:
От: Thomas Munro
Дата:
FAQ