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

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

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql: Create a GUC parameter temp_tablespacesthat allows selection of
Date: 2007-06-05 03:46:08
Message-ID: 200706050346.l553k8H15462@momjian.us (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers
Tom Lane wrote:
> "Simon Riggs" <simon(at)2ndquadrant(dot)com> writes:
> > 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.
> 
> Really?  What if multiple backends are all hitting the same tablespaces
> in the same order?  A random selection seems much less likely to risk
> having any self-synchronizing behavior.

I thought it was going to be random selection for the first tablespace,
and round-robin after that.

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

  + If your life is a hard drive, Christ can be your backup. +

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2007-06-05 03:48:32
Subject: Re: [COMMITTERS] pgsql: Create a GUC parametertemp_tablespacesthatallows selection of
Previous:From: Tom LaneDate: 2007-06-05 01:28:22
Subject: Re: TOAST usage setting

pgsql-committers by date

Next:From: Bruce MomjianDate: 2007-06-05 03:48:32
Subject: Re: [COMMITTERS] pgsql: Create a GUC parametertemp_tablespacesthatallows selection of
Previous:From: Andrew DunstanDate: 2007-06-04 22:21:42
Subject: pgsql: Remove ill-conceived CRLF translation for Windows in syslogger.

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