Where temp table data goes after creation?

4 votes

1 answer

2104 views

                          As far as I can understand temp_buffers setting serve for storing temp tables data.

But as I have created a temp table immediately files gets created for it inside PGDATA along with the main database.
So I would appreciate help on several questions.

 1. What happens with   
   a. temp table data if temp_buffers  is enough to store temp table data? 

     b. temp table data if temp_buffers  is not enough to store temp table data?

2. Is there any case when not enough temp_buffers  setting ends up spilling to pgsql_tmp?

Asked by George K (2306 rep)

Dec 21, 2021, 04:10 PM
Last activity: Dec 21, 2021, 08:02 PM

Where temp table data goes after creation?

Related Questions