Check segments that are in a non-optimal role

posted Oct 9, 2014, 2:43 PM by Sachchida Ojha
Run SQL

select * from gp_segment_configuration where preferred_role <> role;

The segments are not running in their preferred role which implies a skew in processing across the cluster with an uneven # of primary segments on each host. Wait for a potential window and restart the database to bring the segments into preferred role.
Comments