|
|
Subscribe / Log in / New account

PostgreSQL 9.3 beta: Federated databases and more

PostgreSQL 9.3 beta: Federated databases and more

Posted May 16, 2013 17:54 UTC (Thu) by jberkus (guest, #55561)
In reply to: PostgreSQL 9.3 beta: Federated databases and more by ptman
Parent article: PostgreSQL 9.3 beta: Federated databases and more

Actually, we're still arguing about which algorithm to use. Expect to see some algo changes in successive betas.


to post comments

PostgreSQL 9.3 beta: Federated databases and more

Posted May 16, 2013 18:09 UTC (Thu) by andresfreund (subscriber, #69562) [Link] (2 responses)

> Actually, we're still arguing about which algorithm to use. Expect to see some algo changes in successive betas.

I think that ship has sailed and for the on-disk page checksums we are going with the modified FNV.

Explanations about the algorithm:
http://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;...

PostgreSQL 9.3 beta: Federated databases and more

Posted May 17, 2013 7:26 UTC (Fri) by Tobu (subscriber, #24111) [Link] (1 responses)

MurmurHash3 has better throughput and dispersion.

PostgreSQL 9.3 beta: Federated databases and more

Posted May 18, 2013 1:04 UTC (Sat) by luto (guest, #39314) [Link]

And xxhash claims to beat both.

SipHash is also interesting, but probably not for this use case.


Copyright © 2025, Eklektix, Inc.
Comments and public postings are copyrighted by their creators.
Linux is a registered trademark of Linus Torvalds