Skip site navigation (1) Skip section navigation (2)

Re: Postgres 8.5 partitioning

From: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
To: Anj Adu <fotographs(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgres 8.5 partitioning
Date: 2010-04-23 20:35:27
Message-ID: 1272054927.21340.19.camel@hp-laptop2.gunduz.org (view raw or flat)
Thread:
Lists: pgsql-admin
On Fri, 2010-04-23 at 13:27 -0700, Anj Adu wrote:
> We are planning on deploying postgres 8.4 in a month or two to
> production. From the expected feature list for 8.5,

It is already 9.0.

> I have seen one on simplified table partitioning.
> 
> Will 8.5  have table partitions as first-class objects (i.e not
> inheritted tables..but partitions)

No. That patch was not added to 9.0:

https://commitfest.postgresql.org/action/patch_view?id=266

> Also..will 8.5 have a migration option to future releases without
> dump/restore (e.g 8.5 to 9 ) 

There is no such built-in functionality. However, probably pg_migrator
will be available for 9.0, too.

To sum up: 9.0 has big features, like replication, etc. IMHO it won't be
production ready for a few months after it is released (yeah, I'm a bit
optimistic here). So you should stick to 8.4 for now.
-- 
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

In response to

pgsql-admin by date

Next:From: Fernando HeviaDate: 2010-04-23 21:08:16
Subject: RE: REF: Migracion de Sqlserver a Postgresql
Previous:From: Anj AduDate: 2010-04-23 20:27:07
Subject: Postgres 8.5 partitioning

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group