When will table partitioning be available..

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:

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.