Back Java tmp directory by emptyDir for better performance

[sbernauer]

On Trino Slack it was reported that

I didn't see much written about it so I wanted to check if this is just common knowledge. I was able to get up to a 20% speed up on queries that do a lot of reads by switching the java tmp directory to an emptyDir mount. I'm guessing the aircompress library doesn't play nicely with the overlay filesystem.

We should give this a try and see if it improves performance. We can e.g. use the trino-iceberg demo for that.