pgsql/src/include/storage (buf_internals.h relfilenode.h smgr.h)

Started by Vadim B. Mikheev - CVSover 25 years ago5 messagescomitters
Jump to latest
#1Vadim B. Mikheev - CVS
vadim@postgresql.org

Date: Monday, October 16, 2000 @ 10:52:28
Author: vadim

Update of /home/projects/pgsql/cvsroot/pgsql/src/include/storage
from hub.org:/home/projects/pgsql/tmp/cvs-serv67283/include/storage

Modified Files:
buf_internals.h relfilenode.h smgr.h

----------------------------- Log Message -----------------------------

New file naming. Database OID is used as "tablespace" id and
relation OID is used as file node on creation but may be changed later
if required. Regression Tests Approved (c) -:)))

#2Alfred Perlstein
bright@wintelcom.net
In reply to: Vadim B. Mikheev - CVS (#1)
Re: pgsql/src/include/storage (buf_internals.h relfilenode.h smgr.h)

* Vadim B. Mikheev - CVS <vadim@postgresql.org> [001016 07:53] wrote:

Date: Monday, October 16, 2000 @ 10:52:28
Author: vadim

Update of /home/projects/pgsql/cvsroot/pgsql/src/include/storage
from hub.org:/home/projects/pgsql/tmp/cvs-serv67283/include/storage

Modified Files:
buf_internals.h relfilenode.h smgr.h

----------------------------- Log Message -----------------------------

New file naming. Database OID is used as "tablespace" id and
relation OID is used as file node on creation but may be changed later
if required. Regression Tests Approved (c) -:)))

Does this mean that the table/index/etc name isn't dependant on
the filesystem name anymore? we had some messy situations because
a backend crash left us with files in our database directory that
made it impossible for postgresql to create indecies because of
conflicts.

--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: Alfred Perlstein (#2)
Re: pgsql/src/include/storage (buf_internals.h relfilenode.h smgr.h)

Alfred Perlstein <bright@wintelcom.net> writes:

Does this mean that the table/index/etc name isn't dependant on
the filesystem name anymore?

Right. This should clean up the situations where a failed table create/
drop/rename leaves a conflicting filename in the directory.

regards, tom lane

#4Alfred Perlstein
bright@wintelcom.net
In reply to: Tom Lane (#3)
Re: pgsql/src/include/storage (buf_internals.h relfilenode.h smgr.h)

* Tom Lane <tgl@sss.pgh.pa.us> [001016 09:08] wrote:

Alfred Perlstein <bright@wintelcom.net> writes:

Does this mean that the table/index/etc name isn't dependant on
the filesystem name anymore?

Right. This should clean up the situations where a failed table create/
drop/rename leaves a conflicting filename in the directory.

woohoo! :)

7.1 is shaping up to be the coolest.

--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."

#5Tom Lane
tgl@sss.pgh.pa.us
In reply to: Alfred Perlstein (#4)
Re: pgsql/src/include/storage (buf_internals.h relfilenode.h smgr.h)

Alfred Perlstein <bright@wintelcom.net> writes:

woohoo! :)
7.1 is shaping up to be the coolest.

I've only been around this project since 6.3.2. When 6.4 came out, it
was a big improvement. When 6.5 came out, *that* was a big improvement.
When 7.0 came out, it was a huge improvement. 7.1 is looking like
another huge improvement.

I like the trend.

regards, tom lane