Postgres Pro
Downloads
Home   >   mailing lists

Re: now() gives same time within the session - Mailing list pgsql-performance

From Heikki Linnakangas
Subject Re: now() gives same time within the session
Date
Msg-id 4C42C12D.4090403@enterprisedb.com
Whole thread Raw
In response to Re: now() gives same time within the session  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-performance
Tree view 
On 12/07/10 14:15, A. Kretschmer wrote:
> Use timeofday() instead, now() returns the transaction starting time.

timeofday() is a legacy function kept only for backwards-compatibility.
It returns a string, which is quite awkward. Use clock_timestamp() instead.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: performance on new linux box
Next
From: Rajesh Kumar Mallah
Date:
Subject: Re: Pooling in Core WAS: Need help in performance tuning.