supabase
Update supautils.conf.j2 | allow users to log temp files
What kind of change does this PR introduce?
Allow users to log temp files
What is the current behavior?
Users cannot reconfigure the log_temp_files variable
What is the new behavior?
Users can now log temp files, which is necessary for reconfiguring work_mem
Additional context
I was at pgconf_nyc a few weeks ago and I spoke to Christophe Pettus, a Postgres Expert at PGX. He told me that its best practice to log all temp_file creation as it is one of the best ways to know when to modify work_mem. He made a blog post that expounds on his reasoning.
It just so happens that I came across a ticket creating a bunch of GB size temp files and it caused their disk to expand.
Because we now charge for disk provisioned vs. disk used, the "usage" warnings are making this problem much more noticeable to users. Because they're complaining more, there's a need to give them tools to self-manage
