Global Catalog and X Locks

Forum to discuss Vertica performance tuning

Moderator: NorbertKrupa

Post Reply
Victorgm
Beginner
Beginner
Posts: 25
Joined: Fri Jul 17, 2015 2:22 pm

Global Catalog and X Locks

Post by Victorgm » Thu Jul 28, 2016 9:20 pm

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!

Victorgm
Beginner
Beginner
Posts: 25
Joined: Fri Jul 17, 2015 2:22 pm

Re: Global Catalog and X Locks

Post by Victorgm » Mon Aug 01, 2016 11:47 pm

select version() ;
Vertica Analytic Database v7.1.2-1
Running on Amazon's AMI

Post Reply

Return to “Vertica Performance Tuning”

Who is online

Users browsing this forum: No registered users and 2 guests