RE: Status of new relation file naming
От | Mikheev, Vadim |
---|---|
Тема | RE: Status of new relation file naming |
Дата | |
Msg-id | 8F4C99C66D04D4118F580090272A7A23018CC2@SECTORBASE1 обсуждение исходный текст |
Ответ на | Status of new relation file naming ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>) |
Список | pgsql-hackers |
Rename... Why would we need in rename with OID filenames? Ok, let's start with OID (*without tablename prefix|suffix*) filenames and we'll see later how it will work. So, could someone implement OID filenames? (Please use RelFileNode structure). Vadim > > > You have to tell us whether you plan to implement > > > a safe file rename in WAL ? If yes a simple filename > > > without version would be possible and better. > > > > What do you mean? > > The previous discussion we had where we concluded, that > an os rename of a file cannot be done without risc. > But that risc was imho acceptable to avoid the extra version > in the filename > > (a rename back to the old name could fail when the tx is supposed > to be rolled back). > > Search the archive for "file rename sync". > > My conlusion would be an oid only filename, or a mixture of > oid and tablename, where tablename can be wildcarded on a > directory search, > since oid is already unique. No version in the name, we would > do renames in > that case. > > If I remember correctly a patch exists that does oid only filenames. > > Andreas > >
В списке pgsql-hackers по дате отправления: