Re: does work_mem is used on temp tables? - Mailing list pgsql-admin

From Andrew Gierth
Subject Re: does work_mem is used on temp tables?
Date
Msg-id 87efcx7wz1.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to does work_mem is used on temp tables?  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Responses Re: does work_mem is used on temp tables?
Re: does work_mem is used on temp tables?
List pgsql-admin
>>>>> "Mariel" == Mariel Cherkassky <mariel.cherkassky@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)


pgsql-admin by date:

Previous
From: Mariel Cherkassky
Date:
Subject: does work_mem is used on temp tables?
Next
From: Mariel Cherkassky
Date:
Subject: Re: does work_mem is used on temp tables?