RE: [SQL] Alternate disks for Indexes

Поиск
Список
Период
Сортировка
От Shulyak AN
Тема RE: [SQL] Alternate disks for Indexes
Дата
Msg-id XFMail.981026155257.alec@nikts.nk.ukrtel.net
обсуждение исходный текст
Ответ на Alternate disks for Indexes  (pierre@desertmoon.com)
Список pgsql-sql
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
--------------------------------------------------------------------------

В списке pgsql-sql по дате отправления:

Предыдущее
От: pierre@desertmoon.com
Дата:
Сообщение: Alternate disks for Indexes
Следующее
От: Thomas Good
Дата:
Сообщение: Re: [SQL] idiom to mv recs => [NEW] bleeding lock?