Re: How to REINDEX in high volume environments?

From: Mario Weilguni <mweilguni(at)sime(dot)com>
To: shridhar_daithankar(at)persistent(dot)co(dot)in, PostgreSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: How to REINDEX in high volume environments?
Date: 2002-09-29 08:12:56
Message-ID: 200209291012.56234.mweilguni@sime.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Masaru Sugawara 2002-09-29 10:51:01 Does setof record in plpgsql work well in 7.3?
Previous Message Hannu Krosing 2002-09-29 08:08:35 Re: 7.2.3?