Search found 302 matches
- Mon Dec 28, 2015 5:42 am
- Forum: New to Vertica
- Topic: Grant access for a frquently dropped and created table
- Replies: 4
- Views: 26005
Re: Grant access for a frquently dropped and created table
Hi, upgrade to and all your worries will be gone !!! :) Inherited Privileges https://my.vertica.com/docs/7.2.x/HTML/index.htm#Authoring/NewFeatures/7.2/7.2.0/InheritedPrivileges.htm%3FTocPath%3DVertica%25207.2.x%2520New%2520Features%7CNew%2520Features%2520and%2520Changes%2520in%2520Vertica%25207.2.0...
- Fri Nov 27, 2015 2:17 pm
- Forum: New to Vertica Database Administration
- Topic: Partitioning - default Partition
- Replies: 1
- Views: 18641
Re: Partitioning - default Partition
No default partition exist in Vertica. Vertica is a bit different when compared to Postgres in terms of storage. You will need to partition all your data. Even if you partition by potential_id_key, All partitions reside on all nodes in cluster. So every node will have count(distinct(potential_id_key...
- Thu Oct 15, 2015 5:41 pm
- Forum: Vertica Database Administration
- Topic: Question on data collector table dc_allocation_pool_statistics
- Replies: 7
- Views: 16366
Re: Question on data collector table dc_allocation_pool_statistics
Hi Fred, These resource pools generally deal with global catalog size. Since the global catalog is held in memory, this system table shows two types of memory, they both comprise to give you the catalog size which is held in memory by Vertica. So SAL and Global are types of memory and not resource p...
- Tue Sep 22, 2015 7:55 am
- Forum: General
- Topic: How large can the catalog size can be without impacting performance?
- Replies: 4
- Views: 14189
Re: How large can the catalog size can be without impacting performance?
Hi, The recommended size by Vertica is 4-5 GB per node. If your catalog goes beyond this limit, you may start experiencing Slowness on the database. The reason is, Vertica has a single huge Catalog which keeps a track of every single change in the database.The changes include data about objects / sy...
- Tue Sep 01, 2015 9:19 am
- Forum: New to Vertica Database Administration
- Topic: Pin data in memory
- Replies: 3
- Views: 9658
Re: Pin data in memory
Hi, The basic answer would be....Vertica is not an In memory database. The functionality, you are looking for, is found in In-memory databases(Voltdb and many more). Plus, there is no such solution as memcache sitting on Vertica as of yet.. This https://community.dev.hp.com/t5/Vertica-Forum/Periodic...
- Tue Sep 01, 2015 7:24 am
- Forum: Announcements, Events and Activities
- Topic: That Rubic's Cube Guy?
- Replies: 5
- Views: 36376
Re: That Rubic's Cube Guy?
Hey Everybody....
Back to forums after a long time.
I am in for a t-shirt as well.
Back to forums after a long time.
I am in for a t-shirt as well.
- Mon Dec 08, 2014 10:26 pm
- Forum: Vertica Database Administration
- Topic: Running more than one Database
- Replies: 7
- Views: 18243
Re: Running more than one Database
Nice hack Jim.
I had heard about this being possible, but never knew how you do it.
I had heard about this being possible, but never knew how you do it.