Re: About limit on cube dimensions

From: Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>
To: Shida Sato <4246(dot)sato(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: About limit on cube dimensions
Date: 2014-08-31 22:38:49
Message-ID: 5403A3F9.6070104@archidevsys.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 01/09/14 09:05, 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?
>
> ---
> sato
Have you calculated how much disc space you would need to store a cube
with 10000 dimensions???

Hint, an 8 TB disc would be woefully inadequate, unless it was very
sparsely populated.

Cheers,
Gavin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2014-08-31 23:27:08 Re: Small fix in PG 9.4b2 - pg_env.sh
Previous Message Tom Lane 2014-08-31 22:10:37 Re: About limit on cube dimensions