Re: How to REINDEX in high volume environments? - Mailing list pgsql-hackers

From Mario Weilguni
Subject Re: How to REINDEX in high volume environments?
Date
Msg-id 200209291012.56234.mweilguni@sime.com
Whole thread Raw
In response to Re: How to REINDEX in high volume environments?  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
List 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 by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: How to REINDEX in high volume environments?
Next
From: Hannu Krosing
Date:
Subject: Re: 7.2.3?