Re: Unify drop-by-OID functions - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Unify drop-by-OID functions
Date
Msg-id 6ef08d3e-80d8-8731-ea82-bf0b63d040a3@2ndquadrant.com
Whole thread Raw
In response to Re: Unify drop-by-OID functions  (Ranier Vilela <ranier.vf@gmail.com>)
Responses Re: Unify drop-by-OID functions
List pgsql-hackers
On 2020-05-01 23:31, Ranier Vilela wrote:
> I can suggest improvements?
> 
> 1. In case Object is cached, delay open_table until the last moment, for 
> the row to be blocked as little as possible and close the table as 
> quickly as possible.
> 2. In case Object is cached and the tuple is invalid, do not open table.
> 3. Otherwise, is it possible to call systable_endscan, after table_close?

What do you mean by "object is cached"?

In any case, this is a refactoring patch, so significant changes to the 
internal logic would not really be in scope.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: SLRU statistics
Next
From: Tomas Vondra
Date:
Subject: Re: SLRU statistics