Re: [BUGS] Prepared Statement Name Truncation

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [BUGS] Prepared Statement Name Truncation
Дата
Msg-id 19759.1353686028@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [BUGS] Prepared Statement Name Truncation  (Euler Taveira <euler@timbira.com>)
Ответы Re: [BUGS] Prepared Statement Name Truncation  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Список pgsql-general
Euler Taveira <euler@timbira.com> writes:
> On 22-11-2012 04:27, Pavel Stehule wrote:
>>> significantly larger catalog

> Less than 5% of catalog columns? I don't buy your argument.

It's not about count, it's about size.  For instance, pg_attribute
currently requires 140 bytes per row (counting the tuple header and
line pointer), so adding 64 bytes would represent 45% bloat.  In
a database with lots of tables that would be painful.

We could avoid this problem if we were prepared to make type "name"
be varlena, but that would be rather catastrophic because of the
code's habit of overlaying C structures onto catalog rows.

            regards, tom lane


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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: ERROR: query has no destination for result data
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: [BUGS] Prepared Statement Name Truncation