[ADMIN] temporary table space usage

От:

ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca>

Дата:

2 августа 2017 г. в 23:23:58

Hi List
I would like to know if I need a dedicated temporary/"temp"  table space 
for a large wharehouse database > 500GB, how is PG sql optimizer using  
internal temp table ( not the user tables/ session tables),  in special 
I  am thinking about the PG 10 which comes with a improve usage of  
parallelism when compiling SQL .

Isabella