August 19, 2021

Comparison of Oracle PostgreSQL features

Features/Commands comparison between Oracle and PostgreSQL


Oracle Postgres
init.ora postgres.conf
SGA shared_buffers
PGA work_mem
Online Redo log         WAL (Write Ahead Log)
Undo MVCC
Row-chaining         TOAST
Table/Index Relation
Row Tuple
Column Attribute
Data Block Page (on the disk)
Page Buffer (in memory)
Autocommit Off Autocommit On
shutdown abort stop immediate
shut immediate stop fast
shutdown normal         stop smart

Related Oracle Articles: 

No comments:

Post a Comment