pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shulyak AN <alec@nikts.nk.ukrtel.net>
To: pierre@desertmoon.com
Cc: pgsql-sql@postgreSQL.org
Subject: RE: [SQL] Alternate disks for Indexes
Date: Mon, 26 Oct 1998 15:52:57 +0200 (EET)
Message-ID: <XFMail.981026155257.alec@nikts.nk.ukrtel.net> (raw)
In-Reply-To: <19981026132322.12929.qmail@desertmoon.com>


On 26-Oct-98 pierre@desertmoon.com wrote:
> 
> 
> Here is a simple question. In oracle one can specify an alternate location
> for indexes to live(i.e. a different disk) to help improve performance. Is
> it possible to do so in Postgresql? Can I move the indexes then place a
> link from the original location to an alternate disk location and have it
> work?
> 
> Has anyone tried this?
> 
> -=pierre

I did so with PostgreSQL 6.1 an do with 6.3.2. Fof unknown reasones
id didn't work with 6.2.


---
--------------------------------------------------------------------------
  Alexander N Shulyak  |   E-Mail: Shulyak AN <alec@nikts.nk.ukrtel.net>
                       |   Date: 26-Oct-98
 Nikolaev              |   Time: 15:52:47
 Ukraine               |
         This message was sent by XFMail
--------------------------------------------------------------------------



view thread (2+ messages)

Message-ID: <XFMail.981026155257.alec@nikts.nk.ukrtel.net>
Permalink:  ../XFMail.981026155257.alec@nikts.nk.ukrtel.net/
Also on:    postgresql.org/message-id/XFMail.981026155257.alec@nikts.nk.ukrtel.net

 · 

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-sql@postgresql.org
  Cc: alec@nikts.nk.ukrtel.net, pierre@desertmoon.com
  Subject: Re: [SQL] Alternate disks for Indexes
  In-Reply-To: <XFMail.981026155257.alec@nikts.nk.ukrtel.net>
  References: <19981026132322.12929.qmail@desertmoon.com> <XFMail.981026155257.alec@nikts.nk.ukrtel.net>

* 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