Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dn80k-0005sY-D3 for pgsql-docs@arkaria.postgresql.org; Wed, 30 Aug 2017 18:46:46 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dn80j-0006IX-ND for pgsql-docs@arkaria.postgresql.org; Wed, 30 Aug 2017 18:46:45 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dn80j-0006I5-47 for pgsql-docs@postgresql.org; Wed, 30 Aug 2017 18:46:45 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dn80b-0005pD-H2 for pgsql-docs@postgresql.org; Wed, 30 Aug 2017 18:46:44 +0000 Received: from bruce by momjian.us with local (Exim 4.84_2) (envelope-from ) id 1dn80Z-0006Zc-Aq; Wed, 30 Aug 2017 14:46:35 -0400 Date: Wed, 30 Aug 2017 14:46:35 -0400 From: Bruce Momjian To: davecramer@gmail.com Cc: pgsql-docs@postgresql.org Subject: Re: Details of how temp_buffers are actually used would be nice Message-ID: <20170830184635.GA17239@momjian.us> References: <20170627154322.25161.71610@wrigleys.postgresql.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20170627154322.25161.71610@wrigleys.postgresql.org> User-Agent: Mutt/1.5.23 (2014-03-12) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org On Tue, Jun 27, 2017 at 03:43:22PM +0000, davecramer@gmail.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'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 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 + -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs