About varlena2 - Mailing list pgsql-hackers

From Qingqing Zhou
Subject About varlena2
Date
Msg-id Pine.LNX.4.58.0512051639490.31341@eon.cs
Whole thread Raw
Responses Re: About varlena2  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: About varlena2  (ITAGAKI Takahiro <itagaki.takahiro@lab.ntt.co.jp>)
List pgsql-hackers
To reduce size of varlen2.vl_len to int16. This has been mentioned before,
but is there any show-stopper reasoning preventing us from doing that or
somebody has been working on it?

Sorry, just to repeat myself. Char types will benefit from that. Many
applications are from DB2, Oracle or SQL Server:
       Max Char Length
DB2         32672
SQL         8000
Oracle      4000

All of above just need varlena2. To support bigger char types, we could
follow the tradition "long varchar", etc. Or, we can introduce several new
data types like "short varchar" to keep compatible with previous
PostgreSQL applications.

Regards,
Qingqing



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: *printf and zero size
Next
From: Tom Lane
Date:
Subject: Re: *printf and zero size