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
Attachment:
signature.asc
Description: This is a digitally signed message part