Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1eoWsI-0008Kv-R3
	for pgsql-performance@arkaria.postgresql.org; Wed, 21 Feb 2018 16:04:06 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1eoWsH-0008QE-UA
	for pgsql-performance@arkaria.postgresql.org; Wed, 21 Feb 2018 16:04:05 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1eoWsH-0008Q4-K2
	for pgsql-performance@lists.postgresql.org; Wed, 21 Feb 2018 16:04:05 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1eoWsE-0005cq-B4
	for pgsql-performance@postgresql.org; Wed, 21 Feb 2018 16:04:04 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id w1LG404X011882;
	Wed, 21 Feb 2018 11:04:00 -0500
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Rick Otten <rottenwindfish@gmail.com>
cc: "pgsql-performa." <pgsql-performance@postgresql.org>
Subject: Re: blending fast and temp space volumes
In-reply-to: 
 <CAMAYy4JeVqeNFSRuYWT5PZVUdxoidQrfHXX7DHE6N-nmu44WQg@mail.gmail.com>
References: 
 <CAMAYy4JeVqeNFSRuYWT5PZVUdxoidQrfHXX7DHE6N-nmu44WQg@mail.gmail.com>
Comments: In-reply-to Rick Otten <rottenwindfish@gmail.com>
	message dated "Wed, 21 Feb 2018 10:53:18 -0500"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <11880.1519229040.1@sss.pgh.pa.us>
Date: Wed, 21 Feb 2018 11:04:00 -0500
Message-ID: <11881.1519229040@sss.pgh.pa.us>
List-Id: <pgsql-performance.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-performance@lists.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-performance>
Precedence: bulk

Rick Otten <rottenwindfish@gmail.com> writes:
> At the moment it seems like when multiple temp spaces are available, the
> temp spaces are chosen in a 'round robin' or perhaps 'random' fashion.  Is
> that true?

Yes, see fd.c's SetTempTablespaces and GetNextTempTableSpace.
There's no concept of different temp spaces having different performance
characteristics, and anyway we don't really have enough info to make
accurate predictions of temp space consumption.  So it's hard to see the
planner doing this for you automagically.

			regards, tom lane