Thread

  1. Table partitioning - is anything coming?

    Igor Kryltsov <kryltsov@gmail.com> — 2010-07-03T01:55:38Z

    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
    
  2. Re: Table partitioning - is anything coming?

    Greg Smith <greg@2ndquadrant.com> — 2010-07-05T14:05:38Z

    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