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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Distributing index's/tables/logs/etc.
Date: 2002-02-04 05:03:08
Message-ID: 200202040503.g14538j19345@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Lincoln Yeoh wrote:
> At 10:13 PM 03-02-2002 -0500, Bruce Momjian wrote:
> >
> >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.
>
> Just curious: how big can indexes get? Do they get split at X GB boundaries?

Sorry, yes as Tom mentioned, they split at 1 gig boundaries.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kym Farnik 2002-02-04 05:36:10 Re: Comparision of DBs (new to list)
Previous Message Bruce Momjian 2002-02-04 05:00:49 Re: HASH index method not correctly handling NULL text