Add setting temporary_files_buffer_size to control size

Add setting temporary_files_buffer_size to control size of the buffer for temporary files writers. * Optimize memory consumption of scatter operation (used, for example in grace hash join) for LowCardinality columns. #88237 (Vladimir Cherkasov).