PostgreSQL Performance Benchmark using sysbench

Sysbench is a scriptable multi-threaded benchmark tool based on LuaJIT, most frequently used for database benchmarks. Below are the benchmark tests that we can run: -rwxr-xr-x 1 root root 1.5K Feb 10 06:30 bulk_insert.lua -rwxr-xr-x 1 root root 1.3K Feb 10 06:30 oltp_delete.lua -rwxr-xr-x 1 root root 2.4K Feb 10 06:30 oltp_insert.lua -rwxr-xr-x 1 root...

Managing PostgreSQL User and Roles

With PostgreSQL, we can create users and roles with granular access permissions. The new user or role must be selectively granted the required permissions for each database object. To create a PostgreSQL user, use the following SQL statement: CREATE ROLE WITH LOGIN PASSWORD ''; CREATE ROLE WITH NOCREATEDB NOCREATEROLE INHERIT LOGIN CONNECTION LIMIT 100 ENCRYPTED...

PostgreSQL Database Administration Commands

This article lists the  commands used for PostgreSQL administration.Please feel free to suggest and contribute more commands. Login to Database using psql $ psql "service=myservice sslmode=require" $ psql postgresql://dbmaster:5433/mydb?sslmode=require $ psql -U username mydatabase Basic Commands \c dbnameSwitch connection to a new database\lList available databases\dtList available tables\d table_nameDescribe a table such as a column, type,...

Deploying PostgreSQL on a Docker Container

PostgreSQL, often simply "Postgres", is an object-relational database management system (ORDBMS) with an emphasis on extensible and standards-compliance. As a database server, its primary function is to store data, securely and supporting best practices, and retrieve it later, as requested by other software applications, be it those on the same computer or those running on...