On 2017-10-03 17:06:20 +0900, Michael Paquier wrote: > On Tue, Oct 3, 2017 at 3:12 PM, Andres Freund <and...@anarazel.de> wrote: > > On 2017-10-03 03:07:09 +0300, Alexander Korotkov wrote: > >> On Tue, Oct 3, 2017 at 12:32 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > >> +1, > >> I see 3 options there: > >> 1) Drop high-order bit, as you proposed. > >> 2) Allow negative queryIds. > >> 3) Implement unsigned 64-type. > > > > 4) use numeric, efficiency when querying is not a significant concern here > > 5) use a custom type that doesn't support arithmetic, similar to pg_lsn. > > Why not just returning a hexa-like text?
Two reasons: First, it'd look fairly different to before, whereas 4/5 would probably just continue to work fairly transparently in a lot of cases. Secondly, what's the advantage in doing so over 4)? Greetings, Andres Freund -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers