RE: [SQL] Alternate disks for Indexes

From: Shulyak AN <alec(at)nikts(dot)nk(dot)ukrtel(dot)net>
To: pierre(at)desertmoon(dot)com
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: RE: [SQL] Alternate disks for Indexes
Date: 1998-10-26 13:52:57
Message-ID: XFMail.981026155257.alec@nikts.nk.ukrtel.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


On 26-Oct-98 pierre(at)desertmoon(dot)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(at)nikts(dot)nk(dot)ukrtel(dot)net>
| Date: 26-Oct-98
Nikolaev | Time: 15:52:47
Ukraine |
This message was sent by XFMail
--------------------------------------------------------------------------

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Herouth Maoz 1998-10-26 14:57:39 Re: [SQL] idiom to mv recs => [NEW] bleeding lock?
Previous Message pierre 1998-10-26 13:23:22 Alternate disks for Indexes