3 Dec
2010
3 Dec
'10
7:54 a.m.
On Fri, Dec 03, 2010 at 12:12:52PM +0000, Phil Mayers wrote:
On 03/12/10 11:51, Josip Rodin wrote:
I already told PostgreSQL to just stop limiting it, because AFAICT there's no actual benefit.
Under postgresql, there is NO performance benefit or storage space saving using varchar(N) or char(N) over "text". The latter should IMHO always be used, and we modified the SQL schema locally to do that.
I should note that the same is for varchar (character varying) with no specified limit. IOW, alter table radacct alter column callingstationid type varchar; -- 2. That which causes joy or happiness.