Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: temp_buffers and work_mem and big temp tables
Date
Msg-id CAKFQuwZHNzzCmoGS212V1Ahz8gkak_LLmDgKNVq-xnWtj55B5g@mail.gmail.com
Whole thread Raw
In response to temp_buffers and work_mem and big temp tables  (Wells Oliver <wells.oliver@gmail.com>)
Responses Re: temp_buffers and work_mem and big temp tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view

On Tuesday, November 10, 2020, Wells Oliver <wells.oliver@gmail.com> wrote:
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.

IIUC work_mem has nothing to do with temporary tables.  All tables have a disk component and read/writes are done via buffers.

David J.
 

pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: temp_buffers and work_mem and big temp tables
Next
From: Tom Lane
Date:
Subject: Re: temp_buffers and work_mem and big temp tables