Postgres Pro
Downloads
Home   >   mailing lists

Re: More info on pg_stat_activity Wait Event Name when is DataFileRead - Mailing list pgsql-hackers

From PegoraroF10
Subject Re: More info on pg_stat_activity Wait Event Name when is DataFileRead
Date
Msg-id 1618848066062-0.post@n3.nabble.com
Whole thread Raw
In response to Re: More info on pg_stat_activity Wait Event Name when is DataFileRead  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: More info on pg_stat_activity Wait Event Name when is DataFileRead  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Robert Haas
Date:
Subject: Re: Commit 86dc90056 - Rework planning and execution of UPDATE and DELETE
Next
From: Tom Lane
Date:
Subject: Re: Commit 86dc90056 - Rework planning and execution of UPDATE and DELETE