Postgres - should I keep the log file on the fastest drive I wonder your recommendations / experience re database log file (pg_log) placement
We are debating internally if it is worth to keep that on fastest (and expensive) SSD volume, or can be kept on magnetic drives without hitting performance.
Have separate volume dedicated only for this - Id be more than happy to reallocate that to slower HDDs and use this space for DB volume
We have verbose logging (writing almost every single query into log) on and producing 100-200M  log file daily
Engine is PG 12.6 working on Linux.
With the logging_collector enabled, writes are sequential so you can keep log_directory on almost any media.
Assuming average size of a log message is 5 KiB, with a HDD that can do sequential writes at 100 MiB/s you can log 20k messages/second.
So in theory - if you need to you emit tons of logs - you could put them on a separate, cheaper storage.
At the same time, remember that when the log volume fails or is overloaded, it can effectively stop the server (as noted in documentation linked above).