From: Scott Marlowe <scott.marlowe@gmail.com>
To: Marc Mamin <M.Mamin@intershop.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: temp_tablespaces and RAID
Date: Mon, 22 Dec 2008 11:07:24 -0700
Message-ID: <dcc563d10812221007n308aa07eje08fe3b8209018cb@mail.gmail.com> (raw)
In-Reply-To: <C4DAC901169B624F933534A26ED7DF311D52F8@JENMAIL01.ad.intershop.net>
References: <C4DAC901169B624F933534A26ED7DF311D52F8@JENMAIL01.ad.intershop.net>
On Mon, Dec 22, 2008 at 7:40 AM, Marc Mamin <M.Mamin@intershop.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).
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: scott.marlowe@gmail.com, M.Mamin@intershop.de
Subject: Re: temp_tablespaces and RAID
In-Reply-To: <dcc563d10812221007n308aa07eje08fe3b8209018cb@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox