From: Michael P. <mic...@gm...> - 2010-11-30 01:18:40
|
> > Can you remind me regarding statement_timestamp()? From the commit log: > > This commit supports global timestamp values for now(), > statement_timestamp, > transaction_timestamp,current_date, current_time, current_timestamp, > localtime, local_timestamp and now(). > > clock_timestamp and timeofday make their calculation based > on the local server clock so they get their results from the local > node where it is run. > Their use could lead to inconsistencies if used in a transaction > involving several Datanodes. > > > For statement_timestamp() do we perform a separate operation through > GTM, or do we do a delta similar to clock_timestamp()? > statement_timestamo and transaction timestamp base their calculations based on delta calculated with GTM. clock_timestamp does not do anything with GTM, it just uses the local node timestamp. -- Michael Paquier http://michaelpq.users.sourceforge.net |