Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 7A48F632FED for ; Fri, 23 Apr 2010 17:27:20 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 90425-06 for ; Fri, 23 Apr 2010 20:27:05 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-pv0-f174.google.com (mail-pv0-f174.google.com [74.125.83.174]) by mail.postgresql.org (Postfix) with ESMTP id AAB06632C59 for ; Fri, 23 Apr 2010 17:27:09 -0300 (ADT) Received: by pvc7 with SMTP id 7so311647pvc.19 for ; Fri, 23 Apr 2010 13:27:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:date:message-id :subject:from:to:content-type; bh=efQZPY9A9c7LiY/u09EHGmjxfV7pZtM5a4FyYHmY6qA=; b=ueJl2meAeU1fnewcg/BBXQaJ+YfbSeiug2KnPDKPjUdcBAbW0KPzfG4rDnOVobVCol CNxjj78y3bXJCRgQqpyXdGssPiZh2gzOAX7iz1+qoVZOz2a0VB1acTWF4ySJeBCNPXE7 2KBXVn55NON+OdMSyRvJze6z7OnYUm97JXYxU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=ecoVyFoAh3IIIceHXgTeoD+f/x5tg1LG+4TUwolQur+V5ChCd8/H2zIqtEngAkO3Vb nhITHjl3sLgRuSxKY19UxA2ZErlUHHOkQcsO35+3ufitwcScct9K1e3bmrA+tRW4l6J+ VCqT6hs6xR83KLuuvAJ+p+ChpWK2heWZSLmKM= MIME-Version: 1.0 Received: by 10.141.89.13 with SMTP id r13mr764802rvl.236.1272054428025; Fri, 23 Apr 2010 13:27:08 -0700 (PDT) Received: by 10.140.143.7 with HTTP; Fri, 23 Apr 2010 13:27:07 -0700 (PDT) Date: Fri, 23 Apr 2010 13:27:07 -0700 Message-ID: Subject: Postgres 8.5 partitioning From: Anj Adu To: pgsql-admin@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.001 tagged_above=-10 required=5 tests=BAYES_40=-0.001 X-Spam-Level: X-Archive-Number: 201004/323 X-Sequence-Number: 34417 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