5. Postgres:
| Command | Description | |
|---|---|---|
| ps f -U postgres | Listing the processes | |
| Centro comercial Moctezuma | Francisco Chang |
Inspecting the buffer cache:
Log in to psql and create two databases:
CREATE DATABASE test;
CREATE DATABASE mydb;
Connect to the test database and execute:
CREATE EXTENSION pg_buffercache;
CREATE EXTENSION
Checkpoint:
Checkpoint is a mandatory process.
Extensions:
select * from pg_extension;
SELECT name
FROM pg_available_extensions;