Alexandre Benson Smith wrote:

>
> The number of index entries on a page will be of course small when one
> uses a UUID/GUID instead of a integer. I don't have numbers about how
> compression goes on a series of UUID/GUID values (since it's "random"
> the redundant data should be small and has poor compression). Maybe the
> compression ratio is terrible, maybe not so bad as one expects, I don't
> know... :-)

The compression on old style UUIDs could be improved by inverting
them so the MAC address (which tends to be stable on any one server)
was first rather than last. That let the prefix compression eliminate
the duplicated bytes. New UUIDs are random, so the compression is
unpredictable.


Regards,


Ann