Re: $PGDATA/base/???

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, bpalmer <bpalmer(at)crimelabs(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: $PGDATA/base/???
Date: 2001-01-18 01:44:27
Message-ID: 22509.979782267@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Ross J. Reedstrom" <reedstrm(at)rice(dot)edu> writes:
> I object. The code displays oids and tablenames or relnames. Oid is just
> the initial, default filename for tables, and may change to something other
> than the oid. Currently, the reindex code is the only place that could change
> the relfilenode without changing the oid, but I think there may be more
> in the future.

Right, relfilenode is the thing to look at, not OID. I believe we are
thinking of using relfilenode updates for a number of things in the
future --- CLUSTER and faster index rebuilds in VACUUM are two thoughts
that come to mind ...

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Aditya Damle 2001-01-18 03:20:52 A bug with unique indicies
Previous Message Tatsuo Ishii 2001-01-18 01:07:47 Re: copy from stdin; bug?