Postgres 8.5 partitioning

Postgres 8.5 partitioning

am 23.04.2010 22:27:07 von Anj Adu

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

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Postgres 8.5 partitioning

am 23.04.2010 22:35:27 von devrim

--=-0DajhX9KTwuQLrPwfeWt
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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.
>=20
> 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=3D266

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

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.
--=20
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

--=-0DajhX9KTwuQLrPwfeWt
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iEYEABECAAYFAkvSBI4ACgkQtl86P3SPfQ5WFwCfTu6JjmYvnoQV+5GXiYPU 8GvY
dS0AoJlcqilQfW0cSZnytUVEmXEajuad
=Iqla
-----END PGP SIGNATURE-----

--=-0DajhX9KTwuQLrPwfeWt--

Re: Postgres 8.5 partitioning

am 26.04.2010 18:01:29 von Greg Smith

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


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin