Re: Log files polluted with permission denied error messages after every 10 seconds

Hi! > On which files are those complaints? log contains file names: ... 2021-03-06 10:27:51.468 EET [4580] LOG:  could not rename file "pg_wal/000100060092": Permission denied 2021-03-06 10:28:01.526 EET [4580] LOG:  could not rename file "pg_wal/000100060098": Permis

Problematic read queries

Hi Team, We have recently configured replica to our postgres instance. Now the application team wants to move problematic read queries to read replica. We have enabled pg_stat_statements extension. 1. How can I get most load causing queries from pg_stat_statements view whether we can calculate it

Re: Log files polluted with permission denied error messages after every 10 seconds

Hi! These are generated on Windows when removing a past WAL segment, where the process involves a rename followed by durable_unlink() that would generate some LOG entries in the logs if the internal unlink() failed (see RemoveXlogFile() in xlog.c). I changed wal_recycle to off. So checkpointe