Re: Re: performance bottlenecks on lock transactionid

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Re: performance bottlenecks on lock transactionid
Дата
Msg-id 60f01304bbdefa9d091145b77a117df2d7b5a5ca.camel@cybertec.at
обсуждение исходный текст
Ответ на re:Re: performance bottlenecks on lock transactionid  ("王若楠" <wrn@hljdx.net>)
Список pgsql-performance
王若楠 wrote:
> I want to find a way to reduce the lock waiting and improve the
> performance.

You either have to make the transactions shorter, or you let the
different clients modify different rows, so that they don't lock each
other.

That concurrent writers on the same data lock each other is
unavoidable, and all database management systems I know do it the same
way.

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




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

Предыдущее
От: Daulat Ram
Дата:
Сообщение: RE: ORA-24345: A Truncation or null fetch error occurred -ora2pg
Следующее
От: Jean Baro
Дата:
Сообщение: Continuous Performance Test