Skip site navigation (1) Skip section navigation (2)

Re: pgsql: Create a GUC parameter temp_tablespacesthat allows selection of

From: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
To: "Tom Lane" <tgl(at)postgresql(dot)org>
Cc: <pgsql-committers(at)postgresql(dot)org>
Subject: Re: pgsql: Create a GUC parameter temp_tablespacesthat allows selection of
Date: 2007-06-04 18:35:28
Message-ID: 1180982128.2870.70.camel@silverbirch.site (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers
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



In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2007-06-04 18:41:14
Subject: Re: pgsql: Create a GUC parameter temp_tablespacesthat allows selection of
Previous:From: Simon RiggsDate: 2007-06-04 18:12:54
Subject: Re: recovery_target_xid & crashes on the master

pgsql-committers by date

Next:From: Tom LaneDate: 2007-06-04 18:41:14
Subject: Re: pgsql: Create a GUC parameter temp_tablespacesthat allows selection of
Previous:From: Teodor SigaevDate: 2007-06-04 15:59:20
Subject: pgsql: Fix bundle bugs of GIN: - Fix possible deadlock between UPDATE

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group