More columns vs. more rows to optimize storage and performance?
I have a table with this structure:
performance-tuning
How do I move PostgreSQL temp_files to a different tablespace/disk for CURSORs
While working on performance improvements on our PostgreSQL database (Ubuntu Focal, PostgreSQL 13.3), I created a “temporary” tablespace on a fast local NVME drive. This works well and both temporary tables and temp_files created by large queries end up there, taking a lot of load off the main data drive.