Re: Distributing index's/tables/logs/etc.

Поиск
Список
Период
Сортировка
От Arsalan Zaidi
Тема Re: Distributing index's/tables/logs/etc.
Дата
Msg-id 02bb01c1ad6c$8077e9a0$4301a8c0@directi.com
обсуждение исходный текст
Ответ на Re: Distributing index's/tables/logs/etc.  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-general
Thanks for the info everyone....

> Arsalan Zaidi wrote:
> > Hi.
> >
> > I'd like to place my indexs on another partition. There's a hint that
this
> > can be done in one of the docs, but no info as to how one should go
about
> > doing this...
> >
> > I can guess which of the directories under 'base' holds my database, but
how
> > do I recognise and shift the indexs? They're all numbers!
>
> Use /contrib/oid2name to make file numbers to table/database names.
> Then shut down the database and symlink indexes to another device.
> That's all it takes.
>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
>


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

Предыдущее
От: Denis Gasparin
Дата:
Сообщение: Re: Indices for foreign keys
Следующее
От: bombadil@wanadoo.es
Дата:
Сообщение: Views of views, complexity and speed.