Hi,
what are the maximum number of tables that can be created in a schema in vertica?
Thanks,
Raj.
Max number of tables per schema?
Moderator: NorbertKrupa
-
- Intermediate
- Posts: 87
- Joined: Wed Apr 25, 2012 8:10 am
Max number of tables per schema?
Rajasekhar.T|HP ATP Vertica Big Data Solutions V1
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Max number of tables per schema?
Raj,
The SQL Reference Manual says the number of tables/projections per database are limited by physical RAM, as the catalog must fit in memory. I believe that there is not a limitation on the actual number of tables, even by schema.
The SQL Reference Manual says the number of tables/projections per database are limited by physical RAM, as the catalog must fit in memory. I believe that there is not a limitation on the actual number of tables, even by schema.
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.