limit for total number of tuples stay not changed it is a sum of all
'emitted' tuples
Known problem: Limit for deleted tuples does not work for TRUNCATE command

Marcin authored 1 year ago and Marcin committed 1 year ago

The new option can be set for any role with ALTER ROLE or SET statements.
When a role got the option set to 'true' then all its queries are
limited by the supervisor.

Changes in functional test: use the new options instead of 'limted_users'
ALTER ROLE during tests must be used with ;IN DATABASE' to avoid change
global postrges state.

query supervisor: remove option limited_users

Marcin authored 2 years ago and Marcin committed 2 years ago

fix parallel queries crash when loading supervisor
background workers do not check limits, only backend do this
add functional tests