Multi-partition query governor in a computer database system

A networked computer system comprising:

• a first computer system with a first partition of a partitioned database table and a first query governor that estimates a resource cost to execute a query on the first partition;
• a second computer system coupled to the first computer system, the second computer system comprising a second partition of the partitioned database table and a second query governor that estimates a resource cost to execute the query on the second partition;
• a query governor file associated with the database having global governor data, where the global governor data provides governor data to access the first and second partitions, wherein the global governor data includes a plurality of global governor thresholds for the total resource costs to execute a query on the partitioned table on the plurality of partitions, wherein the resource costs comprise at least one of the following:
• total run time of the query, total temporary storage, hard drive activity, and central processing unit cycles;
• wherein the second query governor communicates the estimated resource cost to execute the query on the second partition to the first query governor;
• wherein the first query governor determines a total cost from the estimated cost to execute the query on the first partition summed with the estimated cost to execute the query on the second partition;
• and
• wherein the first query governor determines whether the total cost to execute the query on the plurality of partitions exceeds a global governor threshold of the plurality of global governor thresholds, and allows access to the partitioned table when the total cost to execute the query on the plurality of partitions does not exceed the global governor threshold.

A computer-readable program product comprising:

• a first query governor that estimates a resource cost to execute a query on a first partition of a plurality of partitions;
• a second query governor that estimates a resource cost to execute the query on a second partition of the plurality of partitions;
• a query governor file associated with a database having a partitioned table located on the plurality of partitions, the database having global governor data, where the global governor data provides governor data to access the first and second partitions, wherein the global governor data includes a plurality of global governor thresholds for resource costs to execute a query on the partitioned table on the plurality of partitions, wherein the resource costs comprise at least one of the following:
• total run time of the query, total temporary storage, hard drive activity, and central processing unit cycles;
• wherein the second query governor communicates the estimated resource cost to execute the query on the first partition to the first query governor;
• wherein the first query governor determines the total cost to execute the query from the estimated cost to executed the query on the first partition summed with the estimated cost to execute the query on the second partition;
• wherein the first query governor determines whether the total cost to execute the query on the plurality of partitions exceeds a global governor threshold of the plurality of global governor thresholds, and allows access to the database on the plurality of partitions when the total cost to execute the query on the plurality of partitions does not exceed the global governor threshold;
• and
• non-transistory recordable media bearing the first and second query governor.