Re: does work_mem is used on temp tables?

2018-10-11 Thread Mariel Cherkassky
great, thanks ! ‫בתאריך יום ה׳, 11 באוק׳ 2018 ב-10:42 מאת ‪Andrew Gierth‬‏ <‪ and...@tao11.riddles.org.uk‬‏>:‬ > > "Mariel" == Mariel Cherkassky writes: > > Mariel> Hi, > Mariel> Does the work mem is used when I do sorts or hash operations on > Mariel> temp tables ? Or the temp_buffer tha

Re: does work_mem is used on temp tables?

2018-10-11 Thread Andrew Gierth
> "Mariel" == Mariel Cherkassky writes: Mariel> Hi, Mariel> Does the work mem is used when I do sorts or hash operations on Mariel> temp tables ? Or the temp_buffer that is allocated at the Mariel> beginning of the session is used for it ? work_mem is used for sorts and hashes regardless