Re: does work_mem is used on temp tables?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



>>>>> "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)




[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux