Re: Performance benchmark of PG

2021-07-19 Thread Ninad Shah
As Thomas rightly pointed about the feasibility of benchmarking. You may still compare performance of queries on both Exadata as well as PostgreSQL. IMO, it may not be on par, but it must be acceptable. In the contemporary world, 60TB isn't really a huge database. So, I hardly think you should fin

Re: Performance benchmark of PG

2021-07-19 Thread Manish Lad
Thank you all for your swift response. Thank you again. Manish On Mon, 19 Jul 2021, 15:39 Manish Lad, wrote: > Dear all, >> > 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

Re: Performance benchmark of PG

2021-07-19 Thread Thomas Kellerer
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

Re: Performance benchmark of PG

2021-07-19 Thread Hüseyin Demir
Hi, The question can not be answered in a proper way. Because, in PostgreSQL, performance(response time in query execution events) depends on 1. Your disk/storage hardware. The performance can vary between SSD and HDD for example. 2. Your PostgreSQL configurations. In other words, configuration p

Re: Performance benchmark of PG

2021-07-19 Thread Manish Lad
Yes you are right. I also experienced same in one such migration from db2 to PG which had read faster but the write was not meeting the need. We then noticed the differences in disk types. Once changed it matched the source. Thanks and Regards Manish On Mon, 19 Jul 2021, 16:34 Laurenz Albe, w

Re: Performance benchmark of PG

2021-07-19 Thread Laurenz Albe
On Mon, 2021-07-19 at 15:39 +0530, Manish Lad wrote: > 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 dir

Performance benchmark of PG

2021-07-19 Thread Manish Lad
> > Dear all, > 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 thes