patroni icon indicating copy to clipboard operation
patroni copied to clipboard

Is wal_log_hints still not configurable ?

Open iomatters opened this issue 3 years ago • 4 comments

Environment

  • Patroni version: 2.0.2
  • PostgreSQL version: 11.5

Is there still a way to disable use_pg_rewind and setting wal_log_hints = off respectively ?

Thanks.

iomatters avatar Sep 08 '21 18:09 iomatters

https://github.com/zalando/patroni/issues/1942

CyberDem0n avatar Sep 08 '21 18:09 CyberDem0n

Yes, I looked through that one, I didn't find an explanation on the closure. I agree that not having wal_log_hints/checksums/rewind is a valid use case. I'm currently experiencing a serious performance degradation after switching from the stream replica to Patroni, checked the configs back and forth, the only difference is the wal_log_hints generating tons of WAL iops.

Would you recommend any workaround, what if I disable the rewind and apply a local patch ?

Thanks.

iomatters avatar Sep 08 '21 18:09 iomatters

The issue was closed because nobody was planning to work on it. If you wish to do so - PRs are always welcome.

CyberDem0n avatar Sep 10 '21 07:09 CyberDem0n