Re: How to REINDEX in high volume environments?

Поиск
Список
Период
Сортировка
От Mario Weilguni
Тема Re: How to REINDEX in high volume environments?
Дата
Msg-id 200209291012.56234.mweilguni@sime.com
обсуждение исходный текст
Ответ на Re: How to REINDEX in high volume environments?  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Список pgsql-hackers
Am Samstag, 28. September 2002 10:17 schrieb Shridhar Daithankar:
(snip)
> I have to disagree.. Completely.. This is like turning PG-Metadata into
> registry...
>
> And what happens when index starts splitting when it grows beyond 1GB in
> size?
>
> Putting indexes into a separate subdirectoy and mount/link that directory
> on a device that is on a separate SCSI channel is what I can think of as
> last drop of performance out of it..
(snip)

I think a good approach would be the introduction of tablespaces like oracle has, and assigning locations to that
tablespace.

Best regards,Mario Weilguni


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

Предыдущее
От: "Shridhar Daithankar"
Дата:
Сообщение: Re: How to REINDEX in high volume environments?
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: 7.2.3?