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

From: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
To: (Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Arsalan Zaidi <azaidi(at)directi(dot)com>)
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Distributing index's/tables/logs/etc.
Date: 2002-02-04 04:59:38
Message-ID: 3.0.5.32.20020204125938.009445e0@192.228.128.13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Regards,
Link.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-02-04 05:00:49 Re: HASH index method not correctly handling NULL text
Previous Message Lincoln Yeoh 2002-02-04 04:41:10 Re: PostgreSQL transaction locking problem