Thread

  1. Alternate disks for Indexes

    pierre@desertmoon.com — 1998-10-26T13:23:22Z

    
    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
    
    
  2. RE: [SQL] Alternate disks for Indexes

    Shulyak AN <alec@nikts.nk.ukrtel.net> — 1998-10-26T13:52:57Z

    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
    --------------------------------------------------------------------------