Re: [HACKERS] Interval for launching the table sync worker

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: [HACKERS] Interval for launching the table sync worker
Дата
Msg-id 0c475de6-cbc2-1ec6-2b40-6a21113807de@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Interval for launching the table sync worker  (Masahiko Sawada <sawada.mshk@gmail.com>)
Ответы Re: [HACKERS] Interval for launching the table sync worker  (Petr Jelinek <petr.jelinek@2ndquadrant.com>)
Re: [HACKERS] Interval for launching the table sync worker  (Masahiko Sawada <sawada.mshk@gmail.com>)
Список pgsql-hackers
On 4/13/17 06:23, Masahiko Sawada wrote:
> Attached the latest patch. It didn't actually necessary to change
> GetSubscriptionNotReadyRelations. I just changed the logic refreshing
> the sync table state list.

I think this was the right direction, but then I got worried about
having a loop within a loop to copy over the last start times.  If you
have very many tables, that could be a big nested loop.

Here is an alternative proposal to store the last start times in a hash
table.

(We also might want to lower the interval for the test suite, because
there are intentional failures in there, and this patch or one like it
will cause the tests to run a few seconds longer.)

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

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Вложения

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

Предыдущее
От: Keith Fiske
Дата:
Сообщение: Re: [HACKERS] Passing values to a dynamic background worker
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: [HACKERS] Inadequate parallel-safety check for SubPlans