Re: BitmapHeapScan streaming read user and prelim refactoring

Поиск
Список
Период
Сортировка
Искать
От
Thomas Munro
Тема
Re: BitmapHeapScan streaming read user and prelim refactoring
Дата
Msg-id
CA+hUKGLg_QRgQONVTbRCZC3xRdbuWXtQkVaR+cg0zBxSLoJcRg@mail.gmail.com
Ответ на
Список
Дерево обсуждения
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>
With the unexplained but apparently somewhat systematic regression
patterns on certain tests and settings, I wonder if they might be due
to read_stream.c trying to form larger reads, making it a bit lazier.
It tries to see what the next block will be before issuing the
fadvise.  I think that means that with small I/O concurrency settings,
there might be contrived access patterns where it loses, and needs
effective_io_concurrency to be set one notch higher to keep up, or
something like that.  One way to test that idea would be to run the
tests with io_combine_limit = 1 (meaning 1 block).  It issues advise
eagerly when io_combine_limit is reached, so I suppose it should be
exactly as eager as master.  The only difference then should be that
it automatically suppresses sequential fadvise calls.


В списке pgsql-hackers по дате отправления
От: jian he
Дата:
От: Amit Langote
Дата:
Сообщение: Re: remaining sql/json patches
FAQ