>>>>> "Mariel" == Mariel Cherkassky <mariel.cherkassky@xxxxxxxxx> 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 of what type the underlying table (if any) is. temp_buffers is used to buffer the actual _content_ of temp tables. -- Andrew (irc:RhodiumToad)