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. It shows in extended format with the -x parameter. Usage of the command; pmap -x PID • First, the PID (process id) of the process must be found; $ pgrep

Database Tutorials

29.03.2025

Set Tablespace As Default In Postgresql - Database Tutorials

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, PostgreSQL will, by default, create them in the pg_default Tablespace. If you want to change this, you can use the following parameter. After connecting to Postgresql; SET default_tablespace= createdTableSpaceName; Ex:

Database Tutorials

31.03.2025

How to List Open Files in Linux - Database Tutorials

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 and managing open files is crucial for system administrators and users alike. The Linux operating system provides a powerful utility called lsof (List Open Files) that allows users to gain

Database Tutorials

01.04.2025

PostgreSQL Vacuum - Database Tutorials

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 a table in PostgreSQL, the modified or deleted data is still retained. For example, when you execute an UPDATE operation on a table, the existing data is hidden, and a

home›Database Tutorials

Database Tutorials

Software

Pmap Command In Linux - Database Tutorials

Set Tablespace As Default In Postgresql - Database Tutorials

How to List Open Files in Linux - Database Tutorials

PostgreSQL Vacuum - Database Tutorials

home
›
Database Tutorials