Re: testing HS/SR - 1 vs 2 performance

Поиск
Список
Период
Сортировка
От Dimitri Fontaine
Тема Re: testing HS/SR - 1 vs 2 performance
Дата
Msg-id 87fx2ywieq.fsf@hi-media-techno.com
обсуждение исходный текст
Ответ на Re: testing HS/SR - 1 vs 2 performance  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список pgsql-hackers
Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
>  Changing the KnownAssignedXids data structure from
> hash table into something that's quicker to scan. Preferably something
> with O(N), where N is the number of entries in the data structure, not
> the maximum number of entries it can hold as it is with the hash table
> currently.

So that's pretty good news RedBlack Trees made it in 9.0, isn't it? :)

> A quick fix would be to check if there's any entries in the hash table
> before scanning it. That would eliminate the overhead when there's no
> in-progress transactions in the master. But as soon as there's even one,
> the overhead comes back.

Does not sound like typical, does it?
-- 
dim


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

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: Remaining Streaming Replication Open Items
Следующее
От: Dimitri Fontaine
Дата:
Сообщение: Re: a faster compression algorithm for pg_dump