Re: does work_mem is used on temp tables?

[Mariel Cherkassky]

great, thanks !

‫בתאריך יום ה׳, 11 באוק׳ 2018 ב-10:42 מאת ‪Andrew Gierth‬‏ <‪
and...@tao11.riddles.org.uk‬‏>:‬

> >>>>> "Mariel" == Mariel Cherkassky <mariel.cherkas...@gmail.com> 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)
>