Postgres Pro
Downloads
Home   >   mailing lists

Re: pgsql: Create a GUC parameter temp_tablespacesthat allows selection of - Mailing list pgsql-committers

From Simon Riggs
Subject Re: pgsql: Create a GUC parameter temp_tablespacesthat allows selection of
Date
Msg-id 1180982128.2870.70.camel@silverbirch.site
Whole thread Raw
In response to pgsql: Create a GUC parameter temp_tablespaces that allows selection of  (tgl@postgresql.org (Tom Lane))
Responses Re: pgsql: Create a GUC parameter temp_tablespacesthat allows selection of  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-committers
Tree view 
On Sun, 2007-06-03 at 14:08 -0300, Tom Lane wrote:
> a random list element is chosen each time a temp object is to be
> created

I don't seem to be able to find discussion on this point on -hackers.

One of the main reasons for the implementation was to allow larger
queries to work faster by utilising multiple temp tablespaces for the
same query.

The original ideal implementation was to use round-robin/cyclic
selection, which allows much better usage in the above case. Random
selection works only with larger numbers of users.

Did I miss the discussion, or was this detail not discussed? The
original TODO description mentioned this idea.

--
  Simon Riggs
  EnterpriseDB   http://www.enterprisedb.com

pgsql-committers by date:

Previous
From: teodor@postgresql.org (Teodor Sigaev)
Date:
Subject: pgsql: Fix bundle bugs of GIN: - Fix possible deadlock between UPDATE
Next
From: Tom Lane
Date:
Subject: Re: pgsql: Create a GUC parameter temp_tablespacesthat allows selection of