Re: For production: 8.4 or 8.3? - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: For production: 8.4 or 8.3?
Date
Msg-id 2f4958ff0907280207x6e7ce716g4d7f0cccdba5fa99@mail.gmail.com
Whole thread Raw
In response to Re: For production: 8.4 or 8.3?  (Magnus Hagander <magnus@hagander.net>)
List pgsql-general
I used pg_migrator to migrate my rather large production databases
(couple hundreds GBs). Schemas are easy, as I keep datetimes as
bigints myself (for various reasons) I won't get the float/int
problem.

But I do understand, that keeping dates as floats might cause grief
(unless you create operator that compares timestamps with cast to (0),
etc). But that's another storry.
I wouldn't be afraid to use 8.4. I am using cvs head of postgresql in
testing al the times since 8.1beta , and never had an issue (that
wasn't my own fault).
But goes without saying, every release has bugs, so sooner you test
it, sooner hackers can fix them, if you find one. So my suggestion,
migrate data, do preproduction tests, and stuff. Once you're happy, go
for 8.4

pgsql-general by date:

Previous
From: Sim Zacks
Date:
Subject: count of query results in for loop
Next
From: Andreas Wenk
Date:
Subject: Re: Video available for PGDay SJC '09