Subject: Re: Performance benchmark of PG
To: pgsql-performance@lists.postgresql.org
References: <836265572.4593017.1624590607279.ref@mail.yahoo.com>
 <836265572.4593017.1624590607279@mail.yahoo.com>
 <CADPrz79TBqf4rW9_EreY5oYiAeKoLNVebG5FQr+kc+Lp=HP9Bg@mail.gmail.com>
From: Thomas Kellerer <shammat@gmx.net>
Message-ID: <1fd84b98-0c57-babb-7bc5-14629ea483a7@gmx.net>
Date: Mon, 19 Jul 2021 13:19:19 +0200
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23)
 Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666
MIME-Version: 1.0
In-Reply-To: 
 <CADPrz79TBqf4rW9_EreY5oYiAeKoLNVebG5FQr+kc+Lp=HP9Bg@mail.gmail.com>
Content-Type: text/plain; charset=utf-8
Content-Language: de-DE
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/1fd84b98-0c57-babb-7bc5-14629ea483a7%40gmx.net>
Precedence: bulk

Manish Lad schrieb am 19.07.2021 um 12:09:
> We are planning to migrate Oracle exadata database to postgresql and
> db size ranges from 1 tb to 60 TB.
>
> Will the PG support this with the performance matching to that of
> exadata applince? If anyone could point me in the right direction
> where i xan get the benchmarking done for these two databases either
> on prime or any cloud would be great.


As already pointed out, you won't find such a benchmark.

You will have to run such a benchmark yourself. Ideally with a workload
that represents your use case. Or maybe with something like HammerDB.

But Exadata isn't only software, it's also hardware especially designed
to work together with Oracle's enterprise edition.

So if you want to get any reasonable results, you will at least have to
buy hardware that matches the Exadata HW specifications.

So if you run your own tests, make sure you buy comparable HW for
Postgres as well (lots of RAM and many fast server grade NVMes)