Postgres Pro
Downloads
Home   >   mailing lists

Re: Distributing index's/tables/logs/etc. - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Distributing index's/tables/logs/etc.
Date
Msg-id 200202040503.g14538j19345@candle.pha.pa.us
Whole thread Raw
In response to Re: Distributing index's/tables/logs/etc.  (Lincoln Yeoh <lyeoh@pop.jaring.my>)
Responses Re: Distributing index's/tables/logs/etc.
List pgsql-general
Tree view 
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@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 by date:

Previous
From: Lincoln Yeoh
Date:
Subject: Re: Distributing index's/tables/logs/etc.
Next
From: Bruce Momjian
Date:
Subject: Re: HASH index method not correctly handling NULL text