On Thu, Nov 21, 2013 at 6:15 AM, Andres Freund <and...@2ndquadrant.com> wrote: >> > WRT performance: I agree that fixed-width identifiers are more >> > performant, that's why I went for them, but I am not sure it's that >> > important. The performance sensitive parts should all be done using the >> > internal id the identifier maps to, not the public one. >> >> But I thought the internal identifier was exactly what we're creating. > > Sure. But how often are we a) going to create such an identifier b) > looking it up?
Never. Make that the replication solution's problem. Make the core support deal only with UUIDs or pairs of 64-bit integers or something like that, and let the replication solution decide what they mean. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
