Postgres Pro
Downloads
Home   >   mailing lists

Re: C based plugins, clocks, locks, and configuration variables - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: C based plugins, clocks, locks, and configuration variables
Date
Msg-id 1992cc8b-eaed-5531-844f-ea71599e940c@BlueTreble.com
Whole thread Raw
In response to Re: C based plugins, clocks, locks, and configuration variables  (Craig Ringer <craig.ringer@2ndquadrant.com>)
Responses Re: C based plugins, clocks, locks, and configuration variables
List pgsql-hackers
Tree view 
On 11/3/16 7:14 PM, Craig Ringer wrote:
>> 1) getting microseconds (or nanoseconds) from UTC epoch in a plugin
>
> GetCurrentIntegerTimestamp()

Since you're serializing generation anyway you might want to just forgo 
the timestamp completely. It's not like the values your generating are 
globally unique anymore, or hard to guess.
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)   mobile: 512-569-9461

pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Improving RLS planning
Next
From: Tom Lane
Date:
Subject: Re: Add support for SRF and returning composites to pl/tcl