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

Thu, 26 Jun 2003 09:27:23 -0700 (PDT)
Shirish Reddy <shirish_reddy@yahoo.com>
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?

Fri, 27 Jun 2003 22:27:29 -0500
Bruno Wolff III <bruno@wolff.to>
Re: When will table partitioning be available..
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
>


Sat, 28 Jun 2003 13:02:13 +0800 (WST)
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
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@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.


Mon, 30 Jun 2003 06:19:19 -0600 (MDT)
"scott.marlowe" <scott.marlowe@ihs.com>
Re: When will table partitioning be available..