pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Justin Clift <justin@postgresql.org>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Josh Berkus <josh@agliodbs.com>
Cc: philip johnson <philip.johnson@atempo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: how to configure my new server
Date: Wed, 12 Feb 2003 22:51:56 +1100
Message-ID: <3E4A355C.1040109@postgresql.org> (raw)
In-Reply-To: <200302120552.h1C5q8B09618@candle.pha.pa.us>
References: <200302120552.h1C5q8B09618@candle.pha.pa.us>

Bruce Momjian wrote:
> Josh Berkus wrote:
> 
>>>>how can I put indexes on a seperate disk ?
>>
>>Move the index object (use the oid2name package in /contrib to find the index) 
>>to a different location, and symlink it back to its original location.   Make 
>>sure that you REINDEX at maintainence time, and don't drop and re-create the 
>>index, as that will have the effect of moving it back to the original 
>>location.
> 
> I believe reindex will create a new file and hence remove the symlink,
> at least in 7.3.

Yep, it's a complete pain.  You can't stabily have indexes moved to 
different drives, or even different partitions on the same drive (i.e. 
fastest disk area), as they're recreated in the default data location at 
index time.

This was one of the things I was hoping would _somehow_ be solved with 
namespaces, as in high transaction volume environments it would be nice 
to have frequently used indexes [be practical] on separate drives from 
the data.  At present, that's not very workable.

Regards and best wishes,

Justin Clift

-- 
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
    - Indira Gandhi




view thread (27+ messages)

Message-ID: <3E4A355C.1040109@postgresql.org>
Permalink:  ../3E4A355C.1040109@postgresql.org/
Also on:    postgresql.org/message-id/3E4A355C.1040109@postgresql.org

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: justin@postgresql.org, pgman@candle.pha.pa.us, josh@agliodbs.com, philip.johnson@atempo.com
  Subject: Re: how to configure my new server
  In-Reply-To: <3E4A355C.1040109@postgresql.org>
  References: <200302120552.h1C5q8B09618@candle.pha.pa.us> <3E4A355C.1040109@postgresql.org>

* 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