Franck Pachot Profile picture
🐘 #OpenSource #Distributed #PostgreSQL 🥑 Developer Advocate @Yugabyte​DB ▝▞ 🔸 AWS Data Hero 🅾️ Oracle Certified Master  maybe 𝕏posting to bsky/mstdn/lnkdn
Nov 20, 2023 7 tweets 3 min read
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…
Image
Dec 31, 2022 7 tweets 2 min read
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
Nov 9, 2020 11 tweets 3 min read
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,...
Nov 8, 2020 5 tweets 3 min read
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) ImageImageImage 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. Image
Nov 26, 2019 73 tweets 32 min read
🔴⏬ 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.