Re: Details of how temp_buffers are actually used would be nice

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: davecramer(at)gmail(dot)com
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: Details of how temp_buffers are actually used would be nice
Date: 2017-08-30 18:46:35
Message-ID: 20170830184635.GA17239@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Tue, Jun 27, 2017 at 03:43:22PM +0000, davecramer(at)gmail(dot)com wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/9.6/static/sql-deallocate.html
> Description:
>
> It&#39;s not clear that temp_buffers determine the size of a temp table that
> will be entirely in memory.

Well, it depends what other temp tables are being accessed in the
session as to whether the table is completely in temp_buffers or
overflows to disk.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Dave Cramer 2017-08-30 18:53:10 Re: Details of how temp_buffers are actually used would be nice
Previous Message Daniel Gustafsson 2017-08-30 17:28:55 Re: Change wording for PG_MODULE_MAGIC inclusion