From: Thomas Kellerer <shammat@gmx.net>
To: pgsql-performance@lists.postgresql.org
Subject: Re: Performance benchmark of PG
Date: Mon, 19 Jul 2021 13:19:19 +0200
Message-ID: <1fd84b98-0c57-babb-7bc5-14629ea483a7@gmx.net> (raw)
In-Reply-To: <CADPrz79TBqf4rW9_EreY5oYiAeKoLNVebG5FQr+kc+Lp=HP9Bg@mail.gmail.com>
References: <836265572.4593017.1624590607279.ref@mail.yahoo.com>
<836265572.4593017.1624590607279@mail.yahoo.com>
<CADPrz79TBqf4rW9_EreY5oYiAeKoLNVebG5FQr+kc+Lp=HP9Bg@mail.gmail.com>
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)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: shammat@gmx.net, pgsql-performance@lists.postgresql.org
Subject: Re: Performance benchmark of PG
In-Reply-To: <1fd84b98-0c57-babb-7bc5-14629ea483a7@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox