Trying to find lightweight heartbeat query to determine if a node is up in a Vertica Cluster
We have tried to use a number of different queries to serve as a heartbeat mechanism between our application and our Vertica cluster, and all seem to incur a fair amount of overhead (i.e. global catalog locking, internode communication). Have any of you found a lightweight query to a serve as a heartbeat, or, perhaps, use a different mechanism entirely to determine if a node in your Vertica cluster is up/down?
Thanks in advance