Re: proposal: add columns created and altered to pg_proc and pg_class

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: proposal: add columns created and altered to pg_proc and pg_class
Дата
Msg-id 49E48B20.EE98.0025.0@wicourts.gov
обсуждение исходный текст
Ответ на Re: proposal: add columns created and altered to pg_proc and pg_class  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: proposal: add columns created and altered topg_proc and pg_class  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> wrote: 
> Making pg_class and pg_proc tables larger hurts run-time
performance,
> potentially.  Making a separate table only slows down DDL
operations,
> which are much less frequent.
Copying the pg_class table, with oids and indexes, with and without
the addition of one timestamp column, the timestamp column caused the
copy to be about 11.3% larger; so I see your point.
I guess I didn't realize just how tight the pg_class table was.
Given all that, I'm going to say that from my perspective I don't
think the convenience of saving the information is worth the cost,
with either approach.  I understand it might mean more to others.
-Kevin


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

Предыдущее
От: Devrim GÜNDÜZ
Дата:
Сообщение: Re: Regression failure on RHEL 4 w/ PostgreSQL 8.4 beta1
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Unicode support