RE: Recovery performance of standby for multiple concurrenttruncates on large tables

Поиск
Список
Период
Сортировка
От Tsunakawa, Takayuki
Тема RE: Recovery performance of standby for multiple concurrenttruncates on large tables
Дата
Msg-id 0A3221C70F24FB45833433255569204D1FA753AA@G01JPEXMBYT05
обсуждение исходный текст
Ответ на Re: Recovery performance of standby for multiple concurrent truncateson large tables  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
From: Robert Haas [mailto:robertmhaas@gmail.com]
> It's not clear to me whether it would be worth the overhead of doing
> something like this.

Quite frankly, not really to me, too.

> Making relation drops faster at the cost of
> making buffer cleaning slower could be a loser.

The purpose is not making relation drops faster (on the primary), but keeping failover time within 10 seconds.  I don't
reallyknow how crucial that requirement is, but I'm feeling it would be good for PostgreSQL to be able to guarantee
shorterfailover time.
 


Regards
Takayuki Tsunakawa




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

Предыдущее
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Re: Temporary tables prevent autovacuum, leading to XID wraparound
Следующее
От: "Tsunakawa, Takayuki"
Дата:
Сообщение: RE: Recovery performance of standby for multiple concurrenttruncates on large tables