Re: testing HS/SR - 1 vs 2 performance - Mailing list pgsql-hackers

From Dimitri Fontaine
Subject Re: testing HS/SR - 1 vs 2 performance
Date
Msg-id 87fx2ywieq.fsf@hi-media-techno.com
Whole thread Raw
In response to Re: testing HS/SR - 1 vs 2 performance  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List 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 by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Remaining Streaming Replication Open Items
Next
From: Dimitri Fontaine
Date:
Subject: Re: a faster compression algorithm for pg_dump