Ask HN: Best “I brought down production” story?

Re:Ask HN: Best “I brought down production” story? by truetraveller on Saturday June 26, 2021 @11:49PM (#27648409)

That's over engineering. At this point, just rely on PITR. FWIW, postgres does have a "reaper" via vacuum, but not for the purpose of safety. but rather to allow for mvcc.

[ Parent | on HN ]

Re:Ask HN: Best “I brought down production” story? by brutal_chaos_ on Sunday June 27, 2021 @02:33AM (#27649161)

Hi, if I may, what does PITR stand for?

[ Parent | on HN ]

Re:Ask HN: Best “I brought down production” story? by syncdk on Sunday June 27, 2021 @02:39AM (#27649182)

https://en.wikipedia.org/wiki/Point-in-time_recovery

[ Parent | on HN ]

Re:Ask HN: Best “I brought down production” story? by brutal_chaos_ on Sunday June 27, 2021 @04:11AM (#27649613)

Thanks!

[ Parent | on HN ]

Re:Ask HN: Best “I brought down production” story? by yyyk on Sunday June 27, 2021 @10:26AM (#27651817)

There are other advantages for soft-deletes, like not having to worry about FKs.

[ Parent | on HN ]