Vijaykumar Jain cabecada

## default-config-postgres.sql
CREATE ROLE owner LOGIN ENCRYPTED PASSWORD 'secret' CONNECTION LIMIT 3;
ALTER ROLE owner SET statement_timeout = 20000;
ALTER ROLE owner SET lock_timeout = 3000;
ALTER ROLE owner SET idle_in_transaction_session_timeout = 3000; -- v9.6+

CREATE ROLE readwrite_users NOLOGIN;
CREATE ROLE readonly_users NOLOGIN;

CREATE DATABASE exampledb WITH OWNER owner ENCODING UTF8 LC_COLLATE 'en_US.UTF-8' LC_CTYPE 'en_US.UTF-8';

## notes.md

      
              1 file
            
          
              6 forks
            
          
              0 comments
            
          
              6 stars
            
          
                reterVision
                / notes.md
            
            
              Last active
              March 30, 2023 11:51
            
              
                Linux Performance Tuning
              
          
    1.1 Linux process management


process scheduling
interrupt handling
signaling
process prioritization
process switching
process state
process memory
	CREATE ROLE owner LOGIN ENCRYPTED PASSWORD 'secret' CONNECTION LIMIT 3;
	ALTER ROLE owner SET statement_timeout = 20000;
	ALTER ROLE owner SET lock_timeout = 3000;
	ALTER ROLE owner SET idle_in_transaction_session_timeout = 3000; -- v9.6+

	CREATE ROLE readwrite_users NOLOGIN;
	CREATE ROLE readonly_users NOLOGIN;

	CREATE DATABASE exampledb WITH OWNER owner ENCODING UTF8 LC_COLLATE 'en_US.UTF-8' LC_CTYPE 'en_US.UTF-8';