Max number of tables per schema?

Moderator: NorbertKrupa

Post Reply
rajasekhart
Intermediate
Intermediate
Posts: 87
Joined: Wed Apr 25, 2012 8:10 am

Max number of tables per schema?

Post by rajasekhart » Thu Aug 23, 2012 10:47 am

Hi,

what are the maximum number of tables that can be created in a schema in vertica?

Thanks,
Raj.
Rajasekhar.T|HP ATP Vertica Big Data Solutions V1

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1804
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Max number of tables per schema?

Post by JimKnicely » Thu Aug 23, 2012 1:18 pm

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.
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Database Development”