Re: WIP: Make timestamptz_out less slow. - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: WIP: Make timestamptz_out less slow.
Date
Msg-id 20150914175209.GC55767@alvherre.pgsql
Whole thread Raw
In response to Re: WIP: Make timestamptz_out less slow.  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Responses Re: WIP: Make timestamptz_out less slow.  (David Rowley <david.rowley@2ndquadrant.com>)
List pgsql-hackers
Jim Nasby wrote:
> On 9/13/15 2:43 AM, David Rowley wrote:
> >Are you worried about this because I've not focused on optimising float
> >timestamps as much as int64 timestamps?  Are there many people compiling
> >with float timestamps in the real world?
> 
> My $0.02: the default was changed some 5 years ago so FP time is probably
> pretty rare now.

The default was FP for 8.3 and was changed before 8.4.  Anybody who was
running with the default back then and who has pg_upgraded all the way
to current releases is still using floating-point date/times.

> I don't think it's worth a bunch of extra work to speed them up.

Not sure about that.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Thom Brown
Date:
Subject: jsonb_set array append hack?
Next
From: Alvaro Herrera
Date:
Subject: Re: Attach comments to functions' parameters and return value