Re: Snapshot synchronization, again...

Alvaro Herrera <alvherre@commandprompt.com>

From: Alvaro Herrera <alvherre@commandprompt.com>

To: Tom Lane <tgl@sss.pgh.pa.us>

Cc: Peter Eisentraut <peter_e@gmx.net>, Joachim Wieland <joe@mcknight.de>, Noah Misch <noah@leadboat.com>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2011-02-20T00:57:46Z

Lists: pgsql-hackers

Excerpts from Tom Lane's message of sáb feb 19 21:26:42 -0300 2011:

> However ... IIRC, hash_any gives different results on bigendian and
> littleendian machines.  I'm not sure if a predictable cross-platform
> result is important for this use?  If you're hashing data containing
> native integers, this is a problem anyway.

The current feature only lets you synchronize snapshots within a cluster
-- you can't ship them to another machine.  I don't think dependency on
endianness is a problem here.  (But no, the data doesn't contain native
integers -- it's the snapshot's text representation.)

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support