Thread: When will table partitioning be available..
Hi, One of the issues that is preventing us from migrating from an Oracle DB to Postgres is that Table Partitioning is not available in Postgres yet. Partitioning is still listed as a TO DO. Any ideas when this will be available in Postgres? Approximate time frame will be good enough for now. Thanks Shirish __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com
On Thu, Jun 26, 2003 at 09:27:23 -0700, Shirish Reddy <shirish_reddy@yahoo.com> wrote: > Hi, > > One of the issues that is preventing us from migrating > from an Oracle DB to Postgres is that Table > Partitioning is not available in Postgres yet. > Partitioning is still listed as a TO DO. Any ideas > when this will be available in Postgres? Approximate > time frame will be good enough for now. I haven't heard of anyone actually working on it right now, so it would be hard to give any kind of time frame other than it won't be in 7.4 unless someone jumps out of the woodwork in the next couple of days. Are partial indexes a possible solution for your problem?
A long, long time. Chris On Thu, 26 Jun 2003, Shirish Reddy wrote: > Hi, > > One of the issues that is preventing us from migrating > from an Oracle DB to Postgres is that Table > Partitioning is not available in Postgres yet. > Partitioning is still listed as a TO DO. Any ideas > when this will be available in Postgres? Approximate > time frame will be good enough for now. > > Thanks > Shirish > > __________________________________ > Do you Yahoo!? > SBC Yahoo! DSL - Now only $29.95 per month! > http://sbc.yahoo.com > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >
On Fri, 27 Jun 2003, Bruno Wolff III wrote: > On Thu, Jun 26, 2003 at 09:27:23 -0700, > Shirish Reddy <shirish_reddy@yahoo.com> wrote: > > Hi, > > > > One of the issues that is preventing us from migrating > > from an Oracle DB to Postgres is that Table > > Partitioning is not available in Postgres yet. > > Partitioning is still listed as a TO DO. Any ideas > > when this will be available in Postgres? Approximate > > time frame will be good enough for now. > > I haven't heard of anyone actually working on it right now, so it would > be hard to give any kind of time frame other than it won't be in 7.4 > unless someone jumps out of the woodwork in the next couple of days. > > Are partial indexes a possible solution for your problem? This last sentence makes a very valid point. Just because you solve a problem in Oracle-land one way does not mean the most effective means to solve it in Postgresql-land is by the same methodology. Many solutions in one of these domains will not, and usually should not, have a direct 1 to 1 mapping. It's often better to post what problems you're having in Postgresql and ask the list for advice. The solution may be much simpler than you'd imagine, but without know what the problem is, it's hard to suggest a solution to Shirish Reddy.