Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

In today’s article, we will provide important insights on dead rows, vacuum operations, FSM, and VM in PostgreSQL. When performing UPDATE or DELETE operations on …

In today’s article we will be discussing how to use the “lsof” Command to list open files in Linux. In the world of Linux, understanding …

In today’s article, we will discuss how to change the default Tablespace in PostgreSQL. If you do not specify a different Tablespace when creating objects, …

In this article, we will discuss the pmap command in Linux, which provides a detailed view of the memory usage associated with a specific process. …

In today’s article, we will discuss what PostgreSQL Tablespace is and why it is necessary and give an example. After creating a directory, we give …

In today’s article, we will explain what the IPCS command in Linux is and what it is used for. ipcs shows information on the inter-process …

In today’s article, we will learn how to create a role with SELECT permission and add a newly created user to this role. For example, …

In today’s article, we will be learning how to query virtual memory status with the Free command. 1. The Free command displays the current virtual …

In today’s article, we will discuss PostgreSQL USER EXPIRE. In PostgreSQL, a password must expire to prevent a user from logging in after a specified …

In today’s article, we will be explaining the “ps” command, which is the command we use to monitor running processes in Linux. 1. When run …