Re: does work_mem is used on temp tables?

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

 



great, thanks !

‫בתאריך יום ה׳, 11 באוק׳ 2018 ב-10:42 מאת ‪Andrew Gierth‬‏ <‪andrew@xxxxxxxxxxxxxxxxxxxx‬‏>:‬
>>>>> "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)

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux