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

2021-04-19 Thread Robert Haas
On Mon, Apr 19, 2021 at 12:17 PM PegoraroF10 wrote: > 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

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

2021-04-19 Thread PegoraroF10
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 har

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

2021-04-18 Thread Robert Haas
On Sat, Apr 17, 2021 at 1:58 PM PegoraroF10 wrote: > This long explaining was only to show, at least for me, that would be > desirable to have an additional information when Postgres is waiting for a > file. What if DataFileRead showing relfilenode it´s waiting for ? I agree that this would be ni