Page 1 of 1

Global Catalog and X Locks

Posted: Thu Jul 28, 2016 9:20 pm
by Victorgm
1) What does "Global Catalog" refer to exactly? The manual describes it as a cluster-wide system structure (whereas Local Catalog is at the node level). Is that a collective reference to system tables?

2) Does the GlobalCatalog X lock on a long-running analyze_statistics process mean that if someone else does a create table or a grant (which also have Global Catalog X locks), then they will have to wait for the analyze_statistics to complete?

Many thanks for your help!

Re: Global Catalog and X Locks

Posted: Mon Aug 01, 2016 11:47 pm
by Victorgm
select version() ;
Vertica Analytic Database v7.1.2-1
Running on Amazon's AMI