temp_buffers and work_mem and big temp tables - Mailing list pgsql-admin

From Wells Oliver
Subject temp_buffers and work_mem and big temp tables
Date
Msg-id CAOC+FBVmE5h_p6owdM4CW4Ou9U2DkuH6ypkLKM-iKP=8niMpEA@mail.gmail.com
Whole thread Raw
Responses Re: temp_buffers and work_mem and big temp tables
List 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.

--

pgsql-admin by date:

Previous
From: Ron
Date:
Subject: Re: Move database
Next
From: "David G. Johnston"
Date:
Subject: Re: temp_buffers and work_mem and big temp tables