Horton

Re: performance issue in remove_from_unowned_list()

Robert Haas <robertmhaas@gmail.com>

View thread View on postgr.es
From: Robert Haas <robertmhaas@gmail.com>
To: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>, Postgres hackers <pgsql-hackers@lists.postgresql.org>
Date: 2019-03-13T13:48:26Z
Lists: pgsql-hackers 
On Wed, Mar 13, 2019 at 9:47 AM Tomas Vondra
<tomas.vondra@2ndquadrant.com> wrote:
> AFAICS we already maintain a hash table of the smgr relations, and we
> look them up in this table. We don't need to look them up in the list of
> unowned relations - the whole problem is that with the current
> single-linked list, we need to iterate the list anyway to update pointer
> in the preceding entry.

OK, I'm dumb.  Sorry for the noise.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Commits

  1. Track unowned relations in doubly-linked list