Postgres Pro
Downloads
Home   >   mailing lists

Re: performance issue in remove_from_unowned_list() - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: performance issue in remove_from_unowned_list()
Date
Msg-id 20190310200923.GA4108@alvherre.pgsql
Whole thread Raw
In response to performance issue in remove_from_unowned_list()  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Responses Re: performance issue in remove_from_unowned_list()
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Making all nbtree entries unique by having heap TIDs participatein comparisons
Next
From: Peter Geoghegan
Date:
Subject: Re: Making all nbtree entries unique by having heap TIDs participatein comparisons