MySQL Forums
Forum List  »  Partitioning

Re: MySQL Partitioning: Wish List
Posted by: John Powell
Date: February 12, 2009 08:46AM

I realize that it is a bit of a niche area, but it would be great to be able to include spatial/geometry data type in partitioned tables. It is currently not allowed, see http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitations.html

I am not suggesting using the geometry column in the partition expression (it has to be an int, after all), but it would be useful to be able to partition by month and have geometry columns in the partitions. High frequency spatio-temporal data would greatly benefit from this.

Options: ReplyQuote


Subject
Views
Written By
Posted
8350
December 02, 2007 07:59PM
3285
April 20, 2008 08:31AM
2851
September 21, 2008 10:23AM
2618
November 14, 2008 12:38PM
2359
January 29, 2009 09:11AM
2740
November 24, 2008 08:10AM
2623
February 10, 2009 02:33AM
Re: MySQL Partitioning: Wish List
2701
February 12, 2009 08:46AM
2476
March 27, 2009 10:32PM
2116
June 08, 2009 06:50AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.