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

Re: temp_tablespaces and RAID

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Marc Mamin" <M(dot)Mamin(at)intershop(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: temp_tablespaces and RAID
Date: 2008-12-22 18:07:24
Message-ID: dcc563d10812221007n308aa07eje08fe3b8209018cb@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Mon, Dec 22, 2008 at 7:40 AM, Marc Mamin <M(dot)Mamin(at)intershop(dot)de> wrote:
>
> Hello,
>
> To improve performances, I would like to try moving the temp_tablespaces
> locations outside of our RAID system.
> Is it a good practice ?

Maybe yes, maybe no.  If you move it to a single slow drive, then it
could well slow things down a fair bit when the system needs temp
space. OTOH, if the queries that would need temp space are few and far
between, and they're slowing down the rest of the system in weird
ways, it might be the right thing to do.

I'm afraid we don't have enough information to say if it's the right
thing to do right now, but there are reasons to do it (and not).

In response to

pgsql-performance by date

Next:From: Mark WongDate: 2008-12-23 03:30:05
Subject: Re: dbt-2 tuning results with postgresql-8.3.5
Previous:From: Kevin GrittnerDate: 2008-12-22 15:27:29
Subject: Re: dbt-2 tuning results with postgresql-8.3.5

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