Postgres Frequently used commands - CHEAT SHEET

 \db- List all tablespaces

\dn- List all schemas

Postgresql Database Starts with 100% CPU processes ?

If you have a problem with PostgreSQL, it starts some processes that consume lots of resources. You kill those processes but they will restart after a few minutes.

Later you check the /var/log but there is nothing about this. What does that mean?😟

Oracle : Move indexes to another tablespace

 

Postgres High Availability Terms

 What is High Availability?

It is the amount of time that a service is available and is usually defined by the business.

Oracle Session Kill Script - Session Management

 

Possible ways to recover space from deleted rows with insufficient disk space remaining for full vacuum

 A recent scenario,

We had a single table with about 50M records that use around 80gb of space. Application recently deleted older records which was no longer needed reducing the Number of records to 30M.

What to do if listener log has grown too big in size