Re: performance issue in remove_from_unowned_list()

Поиск
Список
Период
Сортировка
Искать
От
Alvaro Herrera
Тема
Re: performance issue in remove_from_unowned_list()
Дата
Msg-id
20190310200923.GA4108@alvherre.pgsql
Ответ на
Список
Дерево обсуждения
performance issue in remove_from_unowned_list() Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: performance issue in remove_from_unowned_list() Alvaro Herrera <alvherre@2ndquadrant.com>
Re: performance issue in remove_from_unowned_list() Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: performance issue in remove_from_unowned_list() Robert Haas <robertmhaas@gmail.com>
Re: performance issue in remove_from_unowned_list() Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: performance issue in remove_from_unowned_list() Robert Haas <robertmhaas@gmail.com>
Re: performance issue in remove_from_unowned_list() Tomas Vondra <tomas.vondra@2ndquadrant.com>
RE: performance issue in remove_from_unowned_list() "Ideriha, Takeshi" <ideriha.takeshi@jp.fujitsu.com>
Re: performance issue in remove_from_unowned_list() Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: performance issue in remove_from_unowned_list() Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: performance issue in remove_from_unowned_list() Alvaro Herrera <alvherre@2ndquadrant.com>
Re: performance issue in remove_from_unowned_list() Robert Haas <robertmhaas@gmail.com>
Re: performance issue in remove_from_unowned_list() Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: performance issue in remove_from_unowned_list() Tomas Vondra <tomas.vondra@2ndquadrant.com>
On 2019-Feb-07, Tomas Vondra wrote:

> Attached is a WIP patch removing the optimization from DropRelationFiles
> and adding it to smgrDoPendingDeletes. This resolves the issue, at least
> in the cases I've been able to reproduce. But maybe we should deal with
> this issue earlier by ensuring the two lists are ordered the same way
> from the very beginning, somehow.

I noticed that this patch isn't in the commitfest.  Are you planning to
push it soon?

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

В списке pgsql-hackers по дате отправления
От: Heikki Linnakangas
Дата:
От: Peter Geoghegan
Дата:
FAQ