Re: Speedup of relation deletes during recovery

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Speedup of relation deletes during recovery
Дата
Msg-id 20180621174129.hogefyopje4xaznu@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: Speedup of relation deletes during recovery  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: Speedup of relation deletes during recovery  (Thomas Munro <thomas.munro@enterprisedb.com>)
Список pgsql-hackers
On 2018-06-21 14:40:58 +0900, Michael Paquier wrote:
> On Wed, Jun 20, 2018 at 08:43:11PM -0700, Andres Freund wrote:
> > On 2018-06-18 11:13:47 -0700, Andres Freund wrote:
> >> We could do that - but add_to_unowned_list() is actually a bottleneck in
> >> other places during recovery too. We pretty much never (outside of
> >> dropping relations / databases) close opened relations during recovery -
> >> which is obviously problematic since nearly all of the entries are
> >> unowned.  I've come to the conclusion that we should have a global
> >> variable that just disables adding anything to the global lists.
> > 
> > On second thought: I think we should your approach in the back branches,
> > and something like I'm suggesting in master once open.
> 
> +1.  Let's also make sure that the removal of smgrdounlink and
> smgrdounlinkfork happens only on master.

FWIW, I'd just skip removing them. They seem useful functionality and
don't hurt. I don't see the point in mucking around with them.

Greetings,

Andres Freund


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Fast default stuff versus pg_upgrade
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Fast default stuff versus pg_upgrade