Re:Features I'd Like in PostgreSQL
by riku_iki on Saturday January 28, 2023 @06:10PM
(#34562976)
> temp tables don't spill to disk
my setup is local nvme ssd raid, so I hope this part won't be bottle neck.
Also, if you are doing heavy join, where join order and method is need to be controlled, you temp table likely will be large, so you will need to be ready to have disk io.
my setup is local nvme ssd raid, so I hope this part won't be bottle neck. Also, if you are doing heavy join, where join order and method is need to be controlled, you temp table likely will be large, so you will need to be ready to have disk io.