temp_buffers and work_mem and big temp tables

From: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: temp_buffers and work_mem and big temp tables
Date: 2020-11-10 18:53:52
Message-ID: CAOC+FBVmE5h_p6owdM4CW4Ou9U2DkuH6ypkLKM-iKP=8niMpEA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hey all: I was wondering if someone might spell out which setting has more
impact on temporary tables being stored in memory versus disk? I have read
the docs but I thought I'd reach out and ask the community: I keep
increasing both in some scripts where Large Temp Tables are created, but
I'm wondering if it's more efficient just to use one or the other.

Thank you.

--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2020-11-10 19:04:36 Re: temp_buffers and work_mem and big temp tables
Previous Message Ron 2020-11-10 14:24:53 Re: Move database