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

More info on pg_stat_activity Wait Event Name when is DataFileRead

2021-04-17 Thread PegoraroF10
I have a Publication/Subscription. Then 10 days ago my replication just stopped, no one interesting message log on both sides. Then select from pg_stat_replication was empty and some time later, an hour or two, pg_stat_replication came back showing a record like it should. Well, it´s replicating ?