pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres 8.5 partitioning
3+ messages / 3 participants
[nested] [flat]
* Postgres 8.5 partitioning
@ 2010-04-23 20:27 Anj Adu <fotographs@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Anj Adu @ 2010-04-23 20:27 UTC (permalink / raw)
To: pgsql-admin
We are planning on deploying postgres 8.4 in a month or two to
production. From the expected feature list for 8.5, 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)
Also..will 8.5 have a migration option to future releases without
dump/restore (e.g 8.5 to 9 )
If so, we may consider waiting.
Thank you
Sriram
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Postgres 8.5 partitioning
@ 2010-04-23 20:35 Devrim GÜNDÜZ <devrim@gunduz.org>
parent: Anj Adu <fotographs@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Devrim GÜNDÜZ @ 2010-04-23 20:35 UTC (permalink / raw)
To: Anj Adu <fotographs@gmail.com>; +Cc: 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
Attachments:
signature.asc (application/pgp-signature, 197B) download
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Postgres 8.5 partitioning
@ 2010-04-26 16:01 Greg Smith <greg@2ndquadrant.com>
parent: Anj Adu <fotographs@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Greg Smith @ 2010-04-26 16:01 UTC (permalink / raw)
To: Anj Adu <fotographs@gmail.com>; +Cc: pgsql-admin
Anj Adu wrote:
> Will 8.5 have table partitions as first-class objects (i.e not
> inheritted tables..but partitions)
>
What was originally going to be 8.5 was renumbered to be 9.0. None of
the planned partitioning improvements are included in it. The changes
planned there aren't a large as you seem to think they are though.
Partitions will still be inherited tables, the improvements are just
going to reduce the amount of setup/trigger code you need to write and
make management tasks easier.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.us
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2010-04-26 16:01 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-04-23 20:27 Postgres 8.5 partitioning Anj Adu <fotographs@gmail.com>
2010-04-23 20:35 ` Devrim GÜNDÜZ <devrim@gunduz.org>
2010-04-26 16:01 ` Greg Smith <greg@2ndquadrant.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox