Re:Postgres 9.4 feature highlight: Indexing JSON data with j...
by amitlan on Monday November 17, 2014 @06:47AM
(#8617769)
9.4RC1 this week!
Re:Postgres 9.4 feature highlight: Indexing JSON data with j...
by crucialfelix on Monday November 17, 2014 @09:40AM
(#8618341)
Does it not work to use the same data dir and use pg_upgrade ?
I'm just about to upgrade 9.1 - 9.3 and am wondering if that method is advisable.
Re:Postgres 9.4 feature highlight: Indexing JSON data with j...
by pilif on Tuesday November 18, 2014 @12:57AM
(#8622590)
Yes. That works fine between official releases and I've been using it to upgrade in the last 3 years.
However, pg_updrade does not support upgrading between beta releases, which is one of the reasons why I stick to released versions.
Over the last few years, September was always early christmas for me because in September we would be getting the new release. And despite this being a database, their x.y.0 releases were always rock solid (with the exception of 9.2.0 and an issue with IN queries and indexes), so I'm usually upgrading very early.
This year, it looks like the releases is bit late, also caused by some on-disk storage issues for jsonb, so of course I'd like them to spend all the time they need, but I'm still very much looking forward to playing with jsonb as this will provide a nice way of solving some issues I'm having.
I'm not using the beta releases for anything bigger than quickly seeing whether clients still mostly work because updating between beta releases is a PITA due to it requiring a full restore most of the time.
The database I'd like to use jsonb with is 600GB in size and restoring a dump takes 2-6 hours depending on the machine.