How to clean up table in all segments created by an aborted transactions

Post date: May 30, 2013 5:8:59 PM

1.  execute os level command in all the nodes using 

gpssh -f hostfile command.

2. select 'PGOPTIONS=''-c gp_session_role=utility'' psql -p ' || port::text || ' -h ' || hostname || ' -c ' || '<your command here like drop table>'

from gp_segment_configuration 

where role = 'p'

and preferred_role = role

order by hostname, port;

This command should be used by Support only. Not for end user.