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

Поиск
Список
Период
Сортировка
Искать
От
Amit Kapila
Тема
Re: WIP: Avoid creation of the free space map for small tables
Дата
Msg-id
CAA4eK1+Q7iM+B9tfA3UpRi7t8_UkY-5SEFJGOvEBxkZnrkS3zQ@mail.gmail.com
Ответ на
Список
Дерево обсуждения
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 Thu, Nov 29, 2018 at 3:07 PM John Naylor  wrote:
> > Few more comments:
> > -------------------------------
> > 1. I think we can add some test(s) to test the new functionality, may
> > be something on the lines of what Robert has originally provided as an
> > example of this behavior [1].
>
> Done. I tried adding it to several schedules, but for some reason
> vacuuming an empty table failed to truncate the heap to 0 blocks.
> Putting the test in its own group fixed the problem, but that doesn't
> seem ideal.
>

It might be because it fails the should_attempt_truncation() check.
See below code:

if (should_attempt_truncation(vacrelstats))
lazy_truncate_heap(onerel, vacrelstats, vac_strategy);


-- 
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com

В списке pgsql-hackers по дате отправления
От: Dmitry Dolgov
Дата:
От: Dmitry Dolgov
Дата:
FAQ