Managing Spill Files Generated by Queries

Reasons that cause a large number of spill files to be generated include:

Monitoring a Greenplum System contains the following information:

If you have determined that the query must create more spill files than allowed by the value of server configuration parameter , you can increase the value of the parameter.