Search Postgresql Archives

Re: For production: 8.4 or 8.3?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, 2009-07-27 at 19:44 -0400, Tom Lane wrote:

> > because RH really can't be used as a production PostgreSQL server (if
> > date based data is important)
> 
> I have open bugs about the lack of in-place upgrade.  I have never once
> heard a customer complain about FP timestamps.  So your position is
> nonsense.

Most customers wouldn't even understand the problem. We have systems we
have to custom maintain due to PostgreSQL having ghost data because of
the floating point based timestamp storage. 

The problem is very simple. If you run on RH by default you have an
opportunity for data that will disappear in a practical sense. You know
this is true. My response is not nonsense. The data is still there but
it is floating point based and thus, inexact. The where clause that you
expect to retrieve the data, may not. 


Joshua D. Drake

-- 
PostgreSQL - XMPP: jdrake@xxxxxxxxxxxxxxxxxxxxx
   Consulting, Development, Support, Training
   503-667-4564 - http://www.commandprompt.com/
   The PostgreSQL Company, serving since 1997


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux