too long Calling Station Ids

Josip Rodin joy at entuzijast.net
Fri Dec 3 13:54:30 CET 2010


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.



More information about the Freeradius-Users mailing list