Re: Big 7.1 open items

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>, Peter Eisentraut <peter_e(at)gmx(dot)net>, Jan Wieck <JanWieck(at)Yahoo(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>
Subject: Re: Big 7.1 open items
Date: 2000-06-21 16:46:34
Message-ID: 5109.961605994@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
>>>> Are you suggesting that doing dbname/locname is somehow harder to do
>>>> that? If you are, I don't understand why.
>>
>> It doesn't make it harder, but it still seems pointless to have the
>> extra directory level. Bear in mind that if we go with all-OID
>> filenames then you're not going to be looking at "loc1" and "loc2"
>> anyway, but at "5938171" and "8583727". It's not much of a convenience
>> to the admin to see that, so we might as well save a level of directory
>> lookup.

> Just seems easier to have stuff segregates into separate per-db
> directories for clarity. Also, as directories get bigger, finding a
> specific file in there becomes harder. Putting 10 databases all in the
> same directory seems bad in this regard.

Huh? I wasn't arguing against making a db-specific directory below the
tablespace point. I was arguing against making *another* directory
below that one.

> I don't think we want to be using
> symlinks for tables if we can avoid it.

Agreed, but where did that come from? None of these proposals mentioned
symlinks for anything but directories, AFAIR.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2000-06-21 17:05:39 Re: Big 7.1 open items
Previous Message Bruce Momjian 2000-06-21 16:40:35 Re: Big 7.1 open items

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2000-06-21 17:05:39 Re: Big 7.1 open items
Previous Message Tom Lane 2000-06-21 16:42:44 Re: libpq error codes