Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher

Поиск
Список
Период
Сортировка
От Önder Kalacı
Тема Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher
Дата
Msg-id CACawEhUhn4bMuVeBQ30FM-OEtfy7+_UvTMxrYqcCASXEq08C4g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Дерево обсуждения
Hi Andres, Amit, all 

I think the case in which the patch regresses performance in is irrelevant in
practice. 

This is similar to what I think in this context.

I appreciate the effort from Shi Yu, so that we have a clear understanding on the overhead.
But the tests we do on [1] where we observe the regression are largely synthetic test cases
that aim to spot the overhead. 

And having an index over thousands
of non-differing values will generally perform badly, not just in this
context.

Similarly, maybe there are some eccentric use patterns that might follow this. But I also suspect
even if there are such patterns, could they really be performance sensitive?


Thanks,
Onder KALACI

 

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