Re: Write workload is causing severe slowdown in Production

Поиск
Список
Период
Сортировка
От Gnanakumar
Тема Re: Write workload is causing severe slowdown in Production
Дата
Msg-id 00a501cd08f0$11385490$33a8fdb0$@com
обсуждение исходный текст
Ответ на Re: Write workload is causing severe slowdown in Production  ("Tomas Vondra" <tv@fuzzy.cz>)
Список pgsql-performance
> Are those wrapped in a transaction or not? Each transaction forces a fsync
> when committing, and if each of those INSERT/UPDATE statements stands on
> it's own it may cause of lot of I/O.

Yes, it's wrapped inside a transaction.  May be this could be a reason for slowdown, as you've highlighted here.
Atleast,we've got some guidance here to troubleshoot in this aspect also. 

> There are tools that claim to remove the object vs. relational discrepancy
> when accessing the database. They often generate queries on the fly, and
> some of the queries are pretty awful (depends on how well the ORM model is
> defined). There are various reasons why this may suck - loading too much
> data, using lazy fetch everywhere etc.

Thanks for the clarification.

> Are you using something like Hibernate, JPA, ... to handle persistence?

No, we're not using any persistence frameworks/libraries as such.



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

Предыдущее
От: "Tomas Vondra"
Дата:
Сообщение: Re: Write workload is causing severe slowdown in Production
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Write workload is causing severe slowdown in Production