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

From Lincoln Yeoh
Subject Re: Distributing index's/tables/logs/etc.
Date
Msg-id 3.0.5.32.20020204155250.00941e00@192.228.128.13
Whole thread Raw
In response to Re: Distributing index's/tables/logs/etc.  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Oops, sorry. I missed Tom's post.

Link.

At 12:03 AM 04-02-2002 -0500, Bruce Momjian wrote:
>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: "Kym Farnik"
Date:
Subject: Re: Comparision of DBs (new to list)
Next
From: Denis Gasparin
Date:
Subject: Re: Indices for foreign keys