Hi,
When I was going through Vertica documentation, I came across a column called OBJECT_NAME in the system table LOCK_USAGE and the description of the column says "Name of object being locked; can be a table or an internal structure (projection, global catalog, or local catalog)." Can someone throw some insight as to what all constitutes global catalog and local catalog?
Thanks,Fred
Global Catalog and Local Catalog
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Global Catalog and Local Catalog
Global Catalog Locks = Meta-data global across all nodes
- 1. A GCL X lock is required for the following operations:
- DDL Implicit Commit
- DML Explicit Commit
- Refresh
- Recovery
- Segment Balancing
- Inviting a node to join the cluster
- 1. A LCL X lock is required for the following operations:
- DDL Implicit Commit
- DML Explicit Commit
- Moveout
- Mergeout
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.
Re: Global Catalog and Local Catalog
Hi Jim,
Thanks for your time. A couple of clarifications though.
1. Did you mean to say "DDL IMPLICIT COMMIT" and "DML EXPLICIT COMMIT"? as DDL is always IMPLICITILY commited?
2. Why does DML commit need to acquire a GCLX? Is it because thats when AHM advances? which is a global entity?
Thanks, Fred.
Thanks for your time. A couple of clarifications though.
1. Did you mean to say "DDL IMPLICIT COMMIT" and "DML EXPLICIT COMMIT"? as DDL is always IMPLICITILY commited?
2. Why does DML commit need to acquire a GCLX? Is it because thats when AHM advances? which is a global entity?
Thanks, Fred.
Last edited by Fred on Thu Sep 24, 2015 12:33 am, edited 1 time in total.
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Global Catalog and Local Catalog
My guess is because it's across all nodes.Fred wrote:2. Why does DML commit needs to acquire a GCLX? Is it because thats when AHM advances? which is a global entity?
Checkout vertica.tips for more Vertica resources.
Re: Global Catalog and Local Catalog
Thanks Norbert. That makes sense. Also, AHM need not advance at the time of commit itself as I understand AHM advance depends on the Epoch management parameters.
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Global Catalog and Local Catalog
Take a look at my StackExchange answer on AHM.Fred wrote:Thanks Norbert. That makes sense. Also, AHM need not advance at the time of commit itself as I understand AHM advance depends on the Epoch management parameters.
Checkout vertica.tips for more Vertica resources.