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.