Re: [HACKERS] Re: [GENERAL] drop/rename table and transactions

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] Re: [GENERAL] drop/rename table and transactions
Дата
Msg-id 199911300402.XAA26952@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Re: [GENERAL] drop/rename table and transactions  (Michael Robinson <robinson@netrinsics.com>)
Список pgsql-hackers
> Consider had Vadim made this proposal (set the time-travel machine to 
> version 7.1.2 or so):
> 
>     "I'm going to remove WAL from Postgres, so that we can use
>      the table name as the filename for the table on disk."
> 
> So, no, rather than being a major pain, I'd classify it as a minor
> inconvenience.  If it becomes, in fact, a major pain, one can always
> write a two-line psql script that prints a table name, given an oid.

What I am saying is that I want WAL and the old naming system.  I think
name_oid may be a good solution.  For log recover, Vadim can actually
get the oid/name mapping by just getting the file names from the
directories and looking at the names attached to each oid.

Let's not loose the usual names if they can be preserved with little
effort.  Believe me, not keeping readable file names will cause lots of
work for us and for users, so a little work now in keeping the existing
system will save lots of work in the future.

> 
> On an unrelated matter, I haven't been following the "limit elimination"
> effort as closely as I should have.  Is it now possible to compile Postgres
> with 16Kb tuple size, and insert/select 15Kb text fields from the tuples?

I think so.


--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Re: [GENERAL] drop/rename table and transactions
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] sort on huge table