Oracle vs SQL Server vs MySQL vs Postgres
From: kyle Hailey <kylelf_at_gmail.com>
Date: Wed, 1 Mar 2023 12:54:24 -0800
Message-ID: <CADsdiQjG7mH23O8oks7rMGJtKNN0E-bhG1j+LBNj-dvAL0BvYw_at_mail.gmail.com>
Anyone know of good doc on the comparisons across the major RDMS , like the high level performance OMGs?
Date: Wed, 1 Mar 2023 12:54:24 -0800
Message-ID: <CADsdiQjG7mH23O8oks7rMGJtKNN0E-bhG1j+LBNj-dvAL0BvYw_at_mail.gmail.com>
Anyone know of good doc on the comparisons across the major RDMS , like the high level performance OMGs?
Examples
- SQL Server by default is missing row level locking (OMG! of course you can turn it on at a cost)
- Postgres , any open transaction, be it "create table foo(id int); select * from foo; " tanks performance for everyone on the DB doing transactions, everyone.
- Postgres - you wrap your transaction IDs and your database goes down a day or two
- MySQL has similar issue with "create table foo(id int); select * from foo; " where the history length list grows.
- MySQL wait events are worthless. the main wait, like 80% of all waits is a CPU, IO and LOCK all rolled into one, yes indeed, worthless OMG
Kyle
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 01 2023 - 21:54:24 CET