| From: | Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my> |
|---|---|
| To: | (Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>) |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Distributing index's/tables/logs/etc. |
| Date: | 2002-02-04 07:52:50 |
| Message-ID: | 3.0.5.32.20020204155250.00941e00@192.228.128.13 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Denis Gasparin | 2002-02-04 08:19:51 | Re: Indices for foreign keys |
| Previous Message | Kym Farnik | 2002-02-04 05:36:50 | Re: Comparision of DBs (new to list) |