Re: [BUGS] Prepared Statement Name Truncation - Mailing list pgsql-general

From Tom Lane
Subject Re: [BUGS] Prepared Statement Name Truncation
Date
Msg-id 19759.1353686028@sss.pgh.pa.us
Whole thread Raw
In response to Re: [BUGS] Prepared Statement Name Truncation  (Euler Taveira <euler@timbira.com>)
Responses Re: [BUGS] Prepared Statement Name Truncation  (Heikki Linnakangas <hlinnakangas@vmware.com>)
List 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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: ERROR: query has no destination for result data
Next
From: Heikki Linnakangas
Date:
Subject: Re: [BUGS] Prepared Statement Name Truncation