Re: When will table partitioning be available..

On Fri, 27 Jun 2003, Bruno Wolff III wrote:

> On Thu, Jun 26, 2003 at 09:27:23 -0700,
> Shirish Reddy <shirish_reddy(at)yahoo(dot)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.