Re: [HACKERS] 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 [EMAIL PROTECTED] 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. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] When will table partitioning be available..
On Thu, Jun 26, 2003 at 09:27:23 -0700, Shirish Reddy [EMAIL PROTECTED] 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? ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] 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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster