Set a timeout.

Set a timeout.

schema:gisq

Users may accidentally (or deliberately) start queries which would take a very long time to complete. We can set a 'timeout'; this means that the system gives up after a certain amount of time.

SET STATEMENT_TIMEOUT TO 60000

ALTER SYSTEM SET RESOURCE_LIMIT=TRUE;
CREATE PROFILE gisqprofile
   LIMIT CONNECT_TIME 1
   ;
ALTER USER scott PROFILE gisqprofile;

sp_configure 'show advanced options', 1;
reconfigure;
sp_configure 'query governor cost limit', 60;
reconfigure;
sp_configure 'show advanced options', 0
reconfigure

In SQL you can set the session-wide timeout

SET STATEMENT_TIMEOUT TO 60000

You can specify a limit from the system in postgresql.conf

The user scott is limited to 1 minute per connection. After this time he will be logged out, if he is running a query it will be abandoned.

The system estimates the time to complete the query before executing it. If this estimate is more than 60 then the query will not be attempted. This applies to all queries. Individual queries may override this value using the SET QUERY_GOVERNOR_COST_LIMIT command.

Users

Create a new user

Read tables from another schema/database

Change the default schema/database.

Find another process and kill it.

Set a timeout.

Change my own password

Who am I?