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
8396
December 02, 2007 07:59PM
3314
April 20, 2008 08:31AM
2875
September 21, 2008 10:23AM
2652
November 14, 2008 12:38PM
2385
January 29, 2009 09:11AM
2788
November 24, 2008 08:10AM
2662
February 10, 2009 02:33AM
Re: MySQL Partitioning: Wish List
2731
February 12, 2009 08:46AM
2518
March 27, 2009 10:32PM
2136
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.