temp_buffers and work_mem and big temp tables

Поиск
Список
Период
Сортировка
От Wells Oliver
Тема temp_buffers and work_mem and big temp tables
Дата
Msg-id CAOC+FBVmE5h_p6owdM4CW4Ou9U2DkuH6ypkLKM-iKP=8niMpEA@mail.gmail.com
обсуждение исходный текст
Ответы Re: temp_buffers and work_mem and big temp tables
Список 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 по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: Move database
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: temp_buffers and work_mem and big temp tables