Shida Sato wrote > Hi > > Why is there limit on the number of cube dimensions? > It is bit strange because ARRAY has no such limit which is similar to > cube. > Does it relate to Rtree? > Can I use 10000 dimensional cube without R-tree? >From the docs: http://www.postgresql.org/docs/9.4/static/cube.html "To make it harder for people to break things, there is a limit of 100 on the number of dimensions of cubes. This is set in cubedata.h if you need something bigger." Thus the limit is indeed arbitrary - though if you decide to recompile to increase that limit your expectations should be sufficient tempered since likely few (if any) people are using cubes with 100 times the default limit number of dimensions. Given that R-tree is 2-dimensional I'm not sure how it is relevant. The docs also indicate that GIST effectively supersedes R-Tree as an index method... David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/About-limit-on-cube-dimensions-tp5817087p5817090.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
