Check segments that are in a non-optimal role

Post date: Oct 09, 2014 9:43:49 PM

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.