Table partitioning - is anything coming?

Started by Igor Kryltsovover 15 years ago2 messages
#1Igor Kryltsov
kryltsov@gmail.com
1 attachment(s)

Hi Guys,

I am not asking any firm dates but when (and if) do you think roughly
it will be any enhancements on automating partitioning in Postgres?

I am looking at this post -
http://valgogtech.blogspot.com/2008/04/table-partitioning-automation-triggers.html
and thinking of building a simple web page (attached) which will allow
me to build all infrastructure to store log files in partitioned
tables.

As I am a super lazy guy I wanted to know if anything similar is
coming soon officially from you. If anybody have any suggestions on
how to make UI better or can contribute underlying code please email
me on ivk {at} deepshiftlabs {dot} com

Thank you
Igor

Attachments:

partitioner_ui.pngimage/png; name=partitioner_ui.pngDownload
#2Greg Smith
greg@2ndquadrant.com
In reply to: Igor Kryltsov (#1)
Re: Table partitioning - is anything coming?

Igor Kryltsov wrote:

I am not asking any firm dates but when (and if) do you think roughly
it will be any enhancements on automating partitioning in Postgres?

The earliest possible date for that is the summer of 2011 when
PostgreSQL 9.1 might be released:
http://wiki.postgresql.org/wiki/PostgreSQL_9.1_Development_Plan

An outline of the plans is at
http://wiki.postgresql.org/wiki/Table_partitioning and the current patch
submitted to help in this direction is due to be reviewed this month:
https://commitfest.postgresql.org/action/patch_view?id=266

P.S. Attaching PNGs instead of writing text out will annoy some
contributors here, that's not something you want to get into the habit
of on any of the mailing lists here.

--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.us