We’re likely adding a 1TB or 500 GB SSD to our 6TB HDD-based server with the main aim of improving both write performance and also virtual memory performance for people running python on the box. (We’re thinking a Samsung EVO for this, and the solution only needs to last another couple of years.)
I’m having trouble finding good documentation on what temp files other than the WAL could be located on the SSD for postgresql and how much room we should allocate for that. My largest writes are about 14 million lines in a go.
Also, I could use a pointer to how to configure the WAL to go to a specific drive.
--Stephen