Thread: Table partitioning - is anything coming?

Table partitioning - is anything coming?

From
Igor Kryltsov
Date:
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

Attachment

Re: Table partitioning - is anything coming?

From
Greg Smith
Date:
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