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

От

Tsunakawa, Takayuki

Тема

Дата

31 июля 2018 г. в 08:44:03

Msg-id

0A3221C70F24FB45833433255569204D1FA753AA@G01JPEXMBYT05

обсуждение

Ответ на

Re: Recovery performance of standby for multiple concurrent truncateson large tables (Robert Haas)

Список

pgsql-hackers

Дерево обсуждения

Recovery performance of standby for multiple concurrent truncateson large tables "Jamison, Kirk" <k.jamison@jp.fujitsu.com> 10 июля 2018 г. в 10:05:12

Re: Recovery performance of standby for multiple concurrenttruncates on large tables Andres Freund <andres@anarazel.de> 10 июля 2018 г. в 10:14:45

RE: Recovery performance of standby for multiple concurrenttruncates on large tables "Jamison, Kirk" <k.jamison@jp.fujitsu.com> 19 июля 2018 г. в 03:53:14

Re: Recovery performance of standby for multiple concurrenttruncates on large tables 'Andres Freund' <andres@anarazel.de> 19 июля 2018 г. в 23:41:22

RE: Recovery performance of standby for multiple concurrenttruncates on large tables "Jamison, Kirk" <k.jamison@jp.fujitsu.com> 30 июля 2018 г. в 08:22:48

Re: Recovery performance of standby for multiple concurrenttruncates on large tables 'Andres Freund' <andres@anarazel.de> 30 июля 2018 г. в 23:17:04

RE: Recovery performance of standby for multiple concurrenttruncates on large tables "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com> 31 июля 2018 г. в 08:55:36

Re: Recovery performance of standby for multiple concurrent truncateson large tables Robert Haas <robertmhaas@gmail.com> 30 июля 2018 г. в 23:01:53

RE: Recovery performance of standby for multiple concurrenttruncates on large tables "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com> 31 июля 2018 г. в 08:44:03

Re: Recovery performance of standby for multiple concurrenttruncates on large tables Andres Freund <andres@anarazel.de> 30 июля 2018 г. в 23:15:36

Re: Recovery performance of standby for multiple concurrent truncateson large tables Thomas Munro <thomas.munro@enterprisedb.com> 31 июля 2018 г. в 02:26:32

RE: Recovery performance of standby for multiple concurrenttruncates on large tables "Jamison, Kirk" <k.jamison@jp.fujitsu.com> 3 августа 2018 г. в 05:52:35

Re: Recovery performance of standby for multiple concurrent truncateson large tables Ants Aasma <ants.aasma@eesti.ee> 10 июля 2018 г. в 12:21:53

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 really know how crucial that requirement is, but I'm feeling it would be good for PostgreSQL to be able to guarantee shorter failover time.


Regards
Takayuki Tsunakawa

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

Предыдущее

От: Kyotaro HORIGUCHI

Дата: 31 июля 2018 г. в 07:39:07

Сообщение: Re: Temporary tables prevent autovacuum, leading to XID wraparound

Следующее

От: Tsunakawa, Takayuki

Дата: 31 июля 2018 г. в 08:55:36

Сообщение: RE: Recovery performance of standby for multiple concurrenttruncates on large tables