Re:Creating a Document-Store Hybrid in Postgres 9.5
by takeda on Friday February 05, 2016 @10:16PM
(#11046377)
Yes problem were people. Too much politics and that's why I left.
Why more data? In case of IP geolocation neither of that technology understood IPs not to mention being able to create a proper index for ranges.
So in case of Mongo, to get a good performance they decided to generate every possible IPv4 address and map it to zip code. To increase efficiency they stored every IP as a 64 bit integer.
In Coherence they did the same thing, but I guess less efficiently (did not look how it was done, since at the time coherence was in the process of being eliminated) I'm guessing maybe they stored is as a string?
Also note that Coherence is a distributed cache that supposed to withstand couple nodes going down, so a lot of data was duplicated.
Why more data? In case of IP geolocation neither of that technology understood IPs not to mention being able to create a proper index for ranges.
So in case of Mongo, to get a good performance they decided to generate every possible IPv4 address and map it to zip code. To increase efficiency they stored every IP as a 64 bit integer.
In Coherence they did the same thing, but I guess less efficiently (did not look how it was done, since at the time coherence was in the process of being eliminated) I'm guessing maybe they stored is as a string?
Also note that Coherence is a distributed cache that supposed to withstand couple nodes going down, so a lot of data was duplicated.