Re: Performance benchmark of PG

Поиск
Список
Период
Сортировка
От Hüseyin Demir
Тема Re: Performance benchmark of PG
Дата
Msg-id CALqEK1fsrTz9DcV9_3FrYBHEZ9tcqHYqZktv0+xuEJWPgF_XcQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Performance benchmark of PG  (Manish Lad <manishlad7893@gmail.com>)
Список pgsql-performance
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 parameters can change your performance metrics. But you have to define your queries,data size that a query can SELECT each time and queries that INSERTS/UPDATES to database.
3. Your CPU and MEMORY hardwares can also change your performance metrics. You have to compare your hardware infrastructure with Exadata appliances.
4. You also have to consider the connection pooling part in your application part. PostgreSQL can suffer from performance problems because of lack of connection pooling.

Regards.


Manish Lad <manishlad7893@gmail.com>, 19 Tem 2021 Pzt, 14:09 tarihinde şunu yazdı:
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, <laurenz.albe@cybertec.at> wrote:
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 direction where i xan get the benchmarking done
>  for these two databases either on prime or any cloud would be great.

You won't find any trustworthy benchmarks anywhere, because Oracle expressedly
forbids publishing of benchmark results in its license, unless Oracle has given
its permission.

The question cannot be answered, because performance depends on your workload,
configuration, software and hardware.  Perhaps PostgreSQL will be faster, perhaps not.

Test and see.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com



--
Hüseyin Demir

Senior Database Platform Engineer

Linkedin: hseyindemir

В списке pgsql-performance по дате отправления:

Предыдущее
От: Manish Lad
Дата:
Сообщение: Re: Performance benchmark of PG
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: Performance benchmark of PG