Re: WIP: Avoid creation of the free space map for small tables

Поиск
Список
Период
Сортировка
Искать
От
Alvaro Herrera
Тема
Re: WIP: Avoid creation of the free space map for small tables
Дата
Msg-id
20190226152004.GA9037@alvherre.pgsql
Ответ на
Список
Дерево обсуждения
WIP: Avoid creation of the free space map for small tables John Naylor <jcnaylor@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <jcnaylor@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <jcnaylor@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <jcnaylor@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <jcnaylor@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <jcnaylor@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <jcnaylor@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <jcnaylor@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <jcnaylor@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <jcnaylor@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <jcnaylor@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Mithun Cy <mithun.cy@enterprisedb.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <jcnaylor@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Mithun Cy <mithun.cy@enterprisedb.com>
Re: WIP: Avoid creation of the free space map for small tables Mithun Cy <mithun.cy@enterprisedb.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <jcnaylor@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Mithun Cy <mithun.cy@enterprisedb.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Alvaro Herrera <alvherre@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Alvaro Herrera <alvherre@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Alvaro Herrera <alvherre@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Alvaro Herrera <alvherre@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Peter Geoghegan <pg@bowt.ie>
Re: WIP: Avoid creation of the free space map for small tables Alvaro Herrera <alvherre@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Robert Haas <robertmhaas@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Alvaro Herrera <alvherre@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Masahiko Sawada <sawada.mshk@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Masahiko Sawada <sawada.mshk@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Masahiko Sawada <sawada.mshk@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <john.naylor@2ndquadrant.com>
Re: WIP: Avoid creation of the free space map for small tables Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Mithun Cy <mithun.cy@enterprisedb.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <jcnaylor@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <jcnaylor@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Mithun Cy <mithun.cy@enterprisedb.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <jcnaylor@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <jcnaylor@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <jcnaylor@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <jcnaylor@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <jcnaylor@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <jcnaylor@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <jcnaylor@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Robert Haas <robertmhaas@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Robert Haas <robertmhaas@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: Avoid creation of the free space map for small tables Robert Haas <robertmhaas@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Michael Paquier <michael@paquier.xyz>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <jcnaylor@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <jcnaylor@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <jcnaylor@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <jcnaylor@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <jcnaylor@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila <amit.kapila16@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <jcnaylor@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Thomas Munro <thomas.munro@enterprisedb.com>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <jcnaylor@gmail.com>
Re: WIP: Avoid creation of the free space map for small tables Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: Avoid creation of the free space map for small tables John Naylor <jcnaylor@gmail.com>
On 2019-Feb-23, John Naylor wrote:

> On Fri, Feb 22, 2019 at 3:59 AM Amit Kapila  wrote:
> > The reason for not pushing much on making the test pass for
> > nonstandard block sizes is that when I tried existing tests, there
> > were already some failures.
> 
> FWIW, I currently see 8 failures (attached).

Hmm, not great -- even the strings test fails, which seems to try to handle
the case explicitly.  I did expect the plan shape ones to fail, but I'm
surprised about the tablesample one.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

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