Re: -1/0 virtualtransaction

Поиск
Список
Период
Сортировка
От Mike Beachy
Тема Re: -1/0 virtualtransaction
Дата
Msg-id CAEoC5=FAfHpMMCps3ptTB9=VdmojkrPuHWUqN8yj9PH+Bhxo-Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: -1/0 virtualtransaction  (Laurenz Albe <laurenz.albe@cybertec.at>)
Ответы Re: -1/0 virtualtransaction  (Vijaykumar Jain <vijaykumarjain.github@gmail.com>)
Re: -1/0 virtualtransaction  (Thomas Munro <thomas.munro@gmail.com>)
Список pgsql-general
Hi Laurenz -

On Tue, Apr 27, 2021 at 2:56 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
Not sure, but do you see prepared transactions in "pg_prepared_xacts"?

No, the -1 in the virtualtransaction (https://www.postgresql.org/docs/11/view-pg-locks.html) for pg_prepared_xacts was another clue I saw! But, it seems more or less a dead end as I have nothing in pg_prepared_xacts.

Thanks for the idea, though.

I still need to put more effort into Tom's idea about SIReadLock hanging out after the transaction, but some evidence pointing in this direction is that I've reduced the number of db connections and found that the '-1/0' locks will eventually go away! I interpret this as the db needing to find time when no overlapping read/write transactions are present. This doesn't seem completely correct, as I don't have any long lived transactions running while these locks are hanging out. Confusion still remains, for sure.

Mike

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

Предыдущее
От: Ludovico Caldara
Дата:
Сообщение: Re: Oracle vs. PostgreSQL - a comment
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: Approach to creating users in Database