Re: More info on pg_stat_activity Wait Event Name when is DataFileRead

Поиск
Список
Период
Сортировка
От PegoraroF10
Тема Re: More info on pg_stat_activity Wait Event Name when is DataFileRead
Дата
Msg-id 1618848066062-0.post@n3.nabble.com
обсуждение исходный текст
Ответ на Re: More info on pg_stat_activity Wait Event Name when is DataFileRead  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: More info on pg_stat_activity Wait Event Name when is DataFileRead
Список pgsql-hackers
I´m sure problem was hardware and I hope it does not occur anymore.
If I have a logical replication and on replica I do a Vacuum Full, Cluster
or any other EXCLUSIVE LOCK operation which, replication will wait for that.
I was thinking was about a time to release that lock, or in my situation a
hardware problem. If N seconds
 later and that file is not released then change DataFileRead to
DataFileRead + relfilenode



--
Sent from: https://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html



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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Commit 86dc90056 - Rework planning and execution of UPDATE and DELETE
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Commit 86dc90056 - Rework planning and execution of UPDATE and DELETE