| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>, The Hermit Hacker <scrappy(at)hub(dot)org>, PostgreSQL Development <pgsql-hackers(at)postgreSQL(dot)org> |
| Subject: | Re: [HACKERS] Happy column dropping |
| Date: | 2000-01-25 14:14:29 |
| Message-ID: | 200001251414.JAA14452@candle.pha.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> On Mon, 24 Jan 2000, Bruce Momjian wrote:
>
> > New file name will not be just oid. Too hard to administer.
>
> How exactly does this play into administration? You don't actually do a cp
> /usr/local/pgsql/data/base/testdb/mytable /some/where to back up? ;)
>
> What did the Unix kernel programmers think when they first introduced
> inodes? The wrote the readdir() library call. We have that too, it's
> called pg_class.
>
Ingres has table names as numbered files. It is a pain to figure out
which files match which tables. If you need to restore a table from
tape, the pg_class entry is gone and you have no way to figure out the
right table. When analyzing disk space, figuring who is using the space
is a pain.
Every Ingre admin I ever talked to agreed file numbers are a pain.
--
Bruce Momjian | http://www.op.net/~candle
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 | Bruce Momjian | 2000-01-25 14:15:04 | Re: [HACKERS] Happy column dropping |
| Previous Message | Julian Scarfe | 2000-01-25 13:23:58 | Re: [SQL] DISTINCT ON: speak now or forever hold your peace |