Re: About limit on cube dimensions

From: David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: About limit on cube dimensions
Date: 2014-08-31 21:58:39
Message-ID: 1409522319767-5817090.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2014-08-31 22:10:37 Re: About limit on cube dimensions
Previous Message Shida Sato 2014-08-31 21:05:09 About limit on cube dimensions