pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedtemp_tablespaces and RAID
2+ messages / 2 participants
[nested] [flat]
* temp_tablespaces and RAID
@ 2008-12-22 14:40 Marc Mamin <M.Mamin@intershop.de>
0 siblings, 1 reply; 2+ messages in thread
From: Marc Mamin @ 2008-12-22 14:40 UTC (permalink / raw)
To: pgsql-performance
Hello,
To improve performances, I would like to try moving the temp_tablespaces
locations outside of our RAID system.
Is it a good practice ?
Thanks,
Marc Mamin
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: temp_tablespaces and RAID
@ 2008-12-22 18:07 Scott Marlowe <scott.marlowe@gmail.com>
parent: Marc Mamin <M.Mamin@intershop.de>
0 siblings, 0 replies; 2+ messages in thread
From: Scott Marlowe @ 2008-12-22 18:07 UTC (permalink / raw)
To: Marc Mamin <M.Mamin@intershop.de>; +Cc: pgsql-performance
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).
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-12-22 18:07 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-12-22 14:40 temp_tablespaces and RAID Marc Mamin <M.Mamin@intershop.de>
2008-12-22 18:07 ` Scott Marlowe <scott.marlowe@gmail.com>
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