A thread on my first steps in @OracleCloud PostgreSQL managed service👇 #ocipg #ocipg The version is a fork of PostgreSQL 14.9 named "OCI Optimized PostgreSQL"

Reminder - a blog post with the different ways to get the version in PostgreSQL
yugabyte.com/blog/check-pos…

I answered on LinkedIn about how transaction log, redo log, and WAL are the same.

In practice MSSQL transaction log ~= Oracle redo log ~ PostgreSQL WAL
but with more details: 🧵👇🏻 1. A transaction log must include:
- undo log
- redo log
- transaction boundaries
for A,C,I properties of ACID

It can be in memory but must be synced to disk at commit (#LogForceAtCommit) for the D property of ACID

0⃣ I've heard many misconceptions about restoring tablespaces in @OracleDatabase so here a a little #backToTheBasics restore+recover concepts & how-to
👇 1⃣ A tablespace is a subset of the (monolith) database. There are physical operations (backup, transport, snapshot,...) that you don't want to do for the whole TB database. Then you dedicate some tablespaces to applications, datastores, large tables, read-only workloads,...

5 critical features of managed DB services
@awscloud RDS PostgreSQL checks all five 👍

1/5⌚✅be able to recover to a point-in-time beyond the last backup (any point-in-time within the retention) 2/5⏱️✅enable automatic backups (and be warned if not). They occur during the defined window but do not block the database activity. And RDS takes an initial backup at creation.

🔴⏬ Here I start a thread about some Oracle Database concepts. We will see how far it goes - all questions/comments welcome. 🔴⏬ A database (or DBMS - database management system) stores (for short and long term) and manipulates (from many concurrent users/devices) your #data.